Hi,



I'm trying to translate from mysql to pgsql one query as below



SELECT DISTINCT name FROM table ORDER BY surname



Referring to mysql this query was working perfectly, however when I try use
this query with pgsql I didn't achieve result



What should I do?

Why that query doesn't work correctly with pgsql?

In article <ddku0h$cr6$1 (AT) nemesis (DOT) news.tpi.pl>,
"gniewosh" <news (AT) inso (DOT) pl> wrote:

Well, what result are you getting for the MySQL vs PostgreSQL?

Are you sure the same data set is in both databases?

--
Available for Hire! http://amduus.com/Resumes/

There is not a problem with data only with syntax of the sql language,
because as I written I have a query with is working perfectly in mysql. This
query is giving me a list of particular records from column name which are
ordered according to column surname. When I was try to use the same query
for pgsql I have problem, because the database never return me answer.

In article <ddm2fv$hkn$2 (AT) nemesis (DOT) news.tpi.pl>,
"gniewosh" <news (AT) inso (DOT) pl> wrote:


Perhaps you need to add the field to the list of columns to return. I
have to say, when I sort on columns, it is always columns I plan to
display - so I have always had my ORDER BY in the column list of the
SELECT.

--
Available for Hire! http://amduus.com/Resumes/

gniewosh wrote:
I got this on my postgreSQL database:


ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list

Then try
SELECT DISTINCT name, surname ORDER BY surname;

Regards