Hello, i think i am to stupid to use the "with recursive" SQL!
I have a table:
create table tree
(
id_tree integer,
parent_id integer
...
);
In PostgreSQL i use the great connectby() function and in Oracle i simple
use
select * from tree
start with id_tree = 0
connect by parent_id=prior id_
See the developers FAQ for URL's.
---
Les Hazlewood wrote:
>
> Does anyone have a definitive BNF grammar of SQL99 or SQL92? (I'd prefer 99
> but I'll take what I can get ;)
>
> I'm trying to make a simplified XML to SQL
Does anyone have a definitive BNF grammar of SQL99 or SQL92? (I'd prefer 99
but I'll take what I can get ;)
I'm trying to make a simplified XML to SQL translator, and I need the
grammar to do so (not Postgres's grammar...the standard grammar). It must
be available somewhere, because Postgre
Hi there!
Can anybody explain behavior of ?
Or give a link where explanation can be found?
Or something like that ?:)
To my regret, i can't figure it out
right from SQL standard description with my "brute force".
regards,
---
.evgen
---(end of broadcast)---
Ron Peterson <[EMAIL PROTECTED]> writes:
> What organization is currently responsible for drafting SQL standards?
ISO.
> How can I obtain publications describing those standards? Is there
> anything comprehensive and definitive online?
In the US you can buy ISO standards from ANSI, see
http:/
I just recieved SQL in a Nutshell from O'Reilly. I bought the book
because it covers the SQL99 standard. It's my understanding that this
is the most recent SQL standard. Am I correct about this? What is the
current status of SQL standards? What is the most recent approved
standard, and what a
