Limin Liu <limin(at)pumpkinnet(dot)com> writes:
> I just realized that INSERT allows us to have more syntax than the
> manual said. I wonder if we want to elimiate it or keep it with more
> documentation on the INSERT statment?
This will likely go away when we get around to upgrading INSERT to the
full SQL spec --- certainly I'd feel no compunction about removing any
non-SQL syntax that happens to be supported now, if it gets in the way
of spec compliance.
In short, no I don't want to document it, because I don't want people
to start relying on it.
> For the first one, I believe that is due to reusing the definition of
Yes. There's not a lot of difference in the implementations of
INSERT ... VALUES and INSERT ... SELECT, at the moment.
regards, tom lane
In response to
pgsql-hackers by date
|Next:||From: Bruce Momjian||Date: 2001-06-01 04:45:45|
|Subject: Re: Imperfect solutions|
|Previous:||From: Dave Blasby||Date: 2001-05-31 22:49:24|
|Subject: Initial Release of PostGIS|
pgsql-general by date
|Next:||From: Craig Orsinger||Date: 2001-06-01 01:18:53|
|Subject: Re: PostgreSQL security concerns|
|Previous:||From: Tom Lane||Date: 2001-06-01 00:54:20|
|Subject: Re: A question on EFFECTIVE_CACHE_SIZE |