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

: Michael Glaesemann <[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 desi

[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 te

Re: [SQL] help with pagila

seen 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 t

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

[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,