pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedANSI SQL-99 SYNTAX and "WITH"
4+ messages / 4 participants
[nested] [flat]
* ANSI SQL-99 SYNTAX and "WITH"
@ 2004-06-04 19:37 Rein Petersen <rp2969@hotmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Rein Petersen @ 2004-06-04 19:37 UTC (permalink / raw)
To: pgsql-sql
Good morning,afternoon, and evening Everyone,
My research into PostgreSQL documentation has yet to yeild any information about PostgreSQL's support of ANSI SQL-99 syntax, and in particular, the "WITH" clause - which if I understand correctly, allows recursive joins in simple syntax without the use of cursors and/or otherwise klugey SQL.
As you may have guessed, I hope PostgreSQL currently supports the "WITH" clause syntax or, will at least support it imminently.
Any knowledge on the matter is greatly appreciated :)
Rein
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ANSI SQL-99 SYNTAX and "WITH"
@ 2004-06-04 19:51 Yasir Malik <ymalik@cs.stevens-tech.edu>
parent: Rein Petersen <rp2969@hotmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Yasir Malik @ 2004-06-04 19:51 UTC (permalink / raw)
To: Rein Petersen <rp2969@hotmail.com>; +Cc: pgsql-sql
> Good morning,afternoon, and evening Everyone,
>
> My research into PostgreSQL documentation has yet to yeild any information about PostgreSQL's support of ANSI SQL-99 syntax, and in particular, the "WITH" clause - which if I understand correctly, allows recursive joins in simple syntax without the use of cursors and/or otherwise klugey SQL.
>
> As you may have guessed, I hope PostgreSQL currently supports the "WITH" clause syntax or, will at least support it imminently.
No, PostgreSQL does not support the WITH clause. I wanted to use the WITH
clause in an assignment, but I ended up using a view. Maybe that will
work for you.
Yasir
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ANSI SQL-99 SYNTAX and "WITH"
@ 2004-06-04 20:02 Bruno Wolff III <bruno@wolff.to>
parent: Rein Petersen <rp2969@hotmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: Bruno Wolff III @ 2004-06-04 20:02 UTC (permalink / raw)
To: Rein Petersen <rp2969@hotmail.com>; +Cc: pgsql-sql
On Fri, Jun 04, 2004 at 15:37:41 -0400,
Rein Petersen <rp2969@hotmail.com> wrote:
> My research into PostgreSQL documentation has yet to yeild any information about PostgreSQL's support of ANSI SQL-99 syntax, and in particular, the "WITH" clause - which if I understand correctly, allows recursive joins in simple syntax without the use of cursors and/or otherwise klugey SQL.
>
> As you may have guessed, I hope PostgreSQL currently supports the "WITH" clause syntax or, will at least support it imminently.
Postgres doesn't currently support that. Someone was working on it a while
back, but I haven't heard anything lately, so I don't know if some version
of it is going to be in the next release.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: ANSI SQL-99 SYNTAX and "WITH"
@ 2004-06-04 20:43 Tom Lane <tgl@sss.pgh.pa.us>
parent: Bruno Wolff III <bruno@wolff.to>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2004-06-04 20:43 UTC (permalink / raw)
To: Bruno Wolff III <bruno@wolff.to>; +Cc: Rein Petersen <rp2969@hotmail.com>; pgsql-sql
Bruno Wolff III <bruno@wolff.to> writes:
> Rein Petersen <rp2969@hotmail.com> wrote:
>> As you may have guessed, I hope PostgreSQL currently supports the
>> "WITH" clause syntax or, will at least support it imminently.
> Postgres doesn't currently support that. Someone was working on it a while
> back, but I haven't heard anything lately, so I don't know if some version
> of it is going to be in the next release.
Andrew Overholt was working on it awhile back. I've been meaning to
pick up the pieces and see what I could do with it, but at this point
it's a pretty safe bet that it won't make 7.5. Maybe next time.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2004-06-04 20:43 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-04 19:37 ANSI SQL-99 SYNTAX and "WITH" Rein Petersen <rp2969@hotmail.com>
2004-06-04 19:51 ` Yasir Malik <ymalik@cs.stevens-tech.edu>
2004-06-04 20:02 ` Bruno Wolff III <bruno@wolff.to>
2004-06-04 20:43 ` Tom Lane <tgl@sss.pgh.pa.us>
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