pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedRE: ORDER BY in definition of views
5+ messages / 4 participants
[nested] [flat]
* RE: ORDER BY in definition of views
@ 2000-06-08 13:02 Michael Ansley <Michael.Ansley@intecsystems.co.uk>
0 siblings, 1 reply; 5+ messages in thread
From: Michael Ansley @ 2000-06-08 13:02 UTC (permalink / raw)
To: 'Niall Smart' <niall.smart@ebeon.com>; +Cc: pgsql-sql
Would there be a particular reason to do this?
MikeA
>> -----Original Message-----
>> From: Niall Smart [mailto:niall.smart@ebeon.com]
>> Sent: 08 June 2000 14:47
>> To: pgsql-sql@postgresql.org
>> Subject: [SQL] ORDER BY in definition of views
>>
>>
>> Guys,
>>
>> Does anyone know if this is on the radar for 7.1?
>>
>> Niall
>>
>> --
>> Niall Smart
>>
>> email: niall.smart@ebeon.com
>> phone: (087) 8052390
>>
^ permalink raw reply [nested|flat] 5+ messages in thread
* ORDER BY in definition of views
@ 2000-06-08 13:47 Niall Smart <niall.smart@ebeon.com>
0 siblings, 2 replies; 5+ messages in thread
From: Niall Smart @ 2000-06-08 13:47 UTC (permalink / raw)
To: pgsql-sql
Guys,
Does anyone know if this is on the radar for 7.1?
Niall
--
Niall Smart
email: niall.smart@ebeon.com
phone: (087) 8052390
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ORDER BY in definition of views
@ 2000-06-08 14:39 Tom Lane <tgl@sss.pgh.pa.us>
parent: Niall Smart <niall.smart@ebeon.com>
1 sibling, 0 replies; 5+ messages in thread
From: Tom Lane @ 2000-06-08 14:39 UTC (permalink / raw)
To: Niall Smart <niall.smart@ebeon.com>; +Cc: pgsql-sql
Niall Smart <niall.smart@ebeon.com> writes:
> Does anyone know if this is on the radar for 7.1?
7.2 ...
regards, tom lane
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ORDER BY in definition of views
@ 2000-06-08 15:41 Niall Smart <niall.smart@ebeon.com>
parent: Michael Ansley <Michael.Ansley@intecsystems.co.uk>
0 siblings, 0 replies; 5+ messages in thread
From: Niall Smart @ 2000-06-08 15:41 UTC (permalink / raw)
To: Michael Ansley <Michael.Ansley@intecsystems.co.uk>; +Cc: pgsql-sql
Michael Ansley wrote:
>
> Would there be a particular reason to do this?
>
I like to define views for lookups (i.e. job titles,
departments, accounts, whatever). It would be nice
if I could just do a select * from whatever_vw instead
of having to remember to put the order by whatever_name
clause. Admittedly its no biggie, but it is nice-to-have.
Niall
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ORDER BY in definition of views
@ 2000-06-09 10:17 Jan Wieck <JanWieck@t-online.de>
parent: Niall Smart <niall.smart@ebeon.com>
1 sibling, 0 replies; 5+ messages in thread
From: JanWieck@t-online.de @ 2000-06-09 10:17 UTC (permalink / raw)
To: Niall Smart <niall.smart@ebeon.com>; +Cc: pgsql-sql
Niall Smart wrote:
> Guys,
>
> Does anyone know if this is on the radar for 7.1?
Yes, it is not.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2000-06-09 10:17 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-06-08 13:02 RE: ORDER BY in definition of views Michael Ansley <Michael.Ansley@intecsystems.co.uk>
2000-06-08 15:41 ` Niall Smart <niall.smart@ebeon.com>
2000-06-08 13:47 ORDER BY in definition of views Niall Smart <niall.smart@ebeon.com>
2000-06-08 14:39 ` Tom Lane <tgl@sss.pgh.pa.us>
2000-06-09 10:17 ` Jan Wieck <JanWieck@t-online.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox