pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
RE: 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>
  2000-06-08 15:41 ` Re: ORDER BY in definition of views Niall Smart <niall.smart@ebeon.com>
  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

* Re: ORDER BY in definition of views
  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>
  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

* ORDER BY in definition of views
@ 2000-06-08 13:47 Niall Smart <niall.smart@ebeon.com>
  2000-06-08 14:39 ` Re: ORDER BY in definition of views Tom Lane <tgl@sss.pgh.pa.us>
  2000-06-09 10:17 ` Re: ORDER BY in definition of views Jan Wieck <JanWieck@t-online.de>
  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 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>
  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 13:47 ORDER BY in definition of views Niall Smart <niall.smart@ebeon.com>
@ 2000-06-09 10:17 ` Jan Wieck <JanWieck@t-online.de>
  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