[SQL] for SELECT DISTINCT, ORDER BY expressions must appear in select list - is that the standart or a limitation of postgresql?

CREATE TABLE test ( id int4 NOT NULL DEFAULT nextval('teste_id_seq'::regclass), name varchar, number int4 ) WITHOUT OIDS; The data: 1;walter;1 2;walter;1 3;walter;1 4;walter;1 5;walter;2 6;walter;3 7;rodrigo;1 8;rodrigo;2 9;rodrigo;3 The query: SELECT distinct name from test order by

Re: [SQL] for SELECT DISTINCT, ORDER BY expressions must appear in select list - is that the standart or a limitation of postgresql?

[EMAIL PROTECTED] writes: On Feb 15, 2007, at 22:35 , Richard Huxton wrote: Walter Cruz wrote: The error: ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list is due to a standart implementarion or a design decision of postgres? I think ORDER BY is defined to take place

[SQL] help with pagila

Hi all. I'm with a little doubt.I'm testing the pagila (the postgres port of mysql sakila sample).Well, I was trying to translate the query:select film.film_id AS FID, film.title AS title, film.description AS description, category.name AS category, film.rental_rate AS price,

Re: [SQL] help with pagila

So I can assume that the MySQL implementation is strange? (It accepts that kind of query)[]'s- WalterOn 9/1/06, Andrew Sullivan [EMAIL PROTECTED] wrote:On Fri, Sep 01, 2006 at 10:31:48AM -0300, Walter Cruz wrote: ERROR:column film.description must appear in the GROUP BY clause or be used

Re: [SQL] help with pagila

queries like that on a lot of mysql free projects. Maybe we can put that on a FAQ?)[]'s- Walter On 9/1/06, Tom Lane [EMAIL PROTECTED] wrote: Andrew Sullivan [EMAIL PROTECTED] writes: On Fri, Sep 01, 2006 at 02:26:39PM -0300, Walter Cruz wrote: So I can assume that the MySQL implementation is strange