Insert ... (a, b, DEFAULT, c, d); 
Author Message
 Insert ... (a, b, DEFAULT, c, d);

Your patch has been added to the PostgreSQL unapplied patches list at:

        http://www.***.com/

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

Quote:

> Added Copy and Equal nodes -- although InsertDefault doesn't actually
> have any contents.

> Opted for method b as transformTargetList is used in a number of other
> places which are unaffected.  Making them work around the calling
> conventions for a single place seemed silly.

> Previously attached insert.out and insert.sql are the same.

> --
> Rod Taylor

> Your eyes are weary from staring at the CRT. You feel sleepy. Notice
> how restful it is to watch the cursor blink. Close your eyes. The
> opinions stated above are yours. You cannot imagine why you ever felt
> otherwise.

> ----- Original Message -----



> Sent: Saturday, March 30, 2002 2:06 PM
> Subject: Re: [PATCHES] Insert ... (a, b, DEFAULT, c, d);


> > > Adds inserts with defaults.

> > A few gripes about this ---

> > * You can't simply invent a node type without creating any support
> code
> > for it.  See backend/nodes/.  copyfuncs and equalfuncs are
> *required*
> > functionality; infuncs/outfuncs are somewhat more negotiable.  For a
> > node type that never gets past parse analysis it's okay to omit
> infuncs,
> > and you can get away with omitting outfuncs too.

> > * I find it really ugly (not to say fragile) to overload resjunk
> with
> > this meaning.  The best solution would be to restructure the calling
> > conventions for transformTargetList to fix the problem of not being
> able
> > to access all the lists that need to be updated.  Failing that, my
> > inclination would be to pass back the unaltered InsertDefault node
> > (instead of a Resdom) as part of transformTargetList's result list;
> then
> > an IsA test in transformInsertStmt would work to detect which
> entries
> > are real.

> > regards, tom lane

> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 6: Have you searched our list archives?

> > http://www.***.com/

[ Attachment, skipping... ]

[ Attachment, skipping... ]

[ Attachment, skipping... ]

Quote:

> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command


--
  Bruce Momjian                        |   http://www.***.com/

  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Mon, 20 Sep 2004 14:47:54 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Java/CORBA and Adabas/Natural on BS/2000

2. Programmer wanted in BS-Germany

3. B.S. Delphi SQL Error?

4. 10 year BS!

5. Designing queries and other VB BS

6. BS/1 Source Code

7. data from DB in BS 2000 with ERWIN?

8. [BS] - Informatica - PROGRAMMATORE VB 6.0 E SQL SERVER

9. Free of B.S.

10. How to insert non-Unicode CJK string to SQL with DBLIB if SQL default

11. Insert DEFAULT when valued in SP is NULL

12. Inserting NULLs into columns with DEFAULT constraint


 
Powered by phpBB® Forum Software