Home > mailing lists

select where expr in - result order? - Mailing list pgsql-general

From	Andy Kriger
Subject	select where expr in - result order?
Date	November 19, 2002 20:35:22
Msg-id	OJEFIHHAALOBKKJEOMBDKEEFCIAA.akriger@greaterthanone.com Whole thread Raw
List	pgsql-general

Tree view

Is there any way to guarantee that the when using
SELECT * FROM tbl WHERE expr IN (scalar[,...])
the results are returned in the same order as the scalar list?

I realize I can do this by sorting the scalar list and using ORDER BY expr,
but I'd like to not count on a sorted list of scalars if at all possible.

thx
andy

pgsql-general by date:

From: Medi Montaseri
Date: 19 November 2002, 20:06:13
Subject: Re: Getting a list of tables in a database with Perl

From: Doug McNaught
Date: 19 November 2002, 21:20:06
Subject: Re: select where expr in - result order?

select where expr in - result order? - Mailing list pgsql-general

Previous

Next