Re: how to set a DEFAULT value !!


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


DBI is complex enough, and AIUI the DBI philosophy opposes adding features
to the core that will cause implementation headaches for driver authors.

The standard perl idiom for default values is

You misunderstand. The DEFAULT is on the database side, not the client, and
is represented by sending the literal string 'DEFAULT' to the backend,
similar to the way that null values are sent by the literal string 'NULL'.
The database then populates the column with whatever the default has been
set as, which may be a constant, or may be (in PostgreSQL's case) an arbitrarily
complex expression or call to a stored procedure.

- --
Greg Sabino Mullane greg@xxxxxxxxxxxx
PGP Key: 0x14964AC8 200604262344
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

-----BEGIN PGP SIGNATURE-----

iD8DBQFEUD4jvJuQZxSWSsgRAjUPAJ9X8mTMNT2cPZYCPHVFVuBr2ydccQCdFFma
BbE1KNnv1ofBwOkd8UhOFM8=
=j+L7
-----END PGP SIGNATURE-----


.

Relevant Pages

  • Re: db editor
    ... You're right - you did misunderstand me - thanks for coming back and ... what I would have done after adding new fields to a database. ... >> I can edit the fields of existing records and the updates are reflected - ... >>> Spider Web Woman Designs ...
    (microsoft.public.frontpage.programming)
  • Re: Need help please with making this SELECT statement work!!!!!!
    ... There is a touch and feel to good database work. ... Training yourself to misunderstand this "touch and feel" would be highly ... >>my original design is not a relational ...
    (microsoft.public.access.queries)
  • Re: Moving users from one db to another
    ... Perhaps I misunderstand, but users and groups are not stored in the database. ... Just secure the other database using the same workgroup file, and it will have all it needs to recognize the users/groups. ...
    (microsoft.public.access.security)