From: | Danny <dannyh(at)idx(dot)com(dot)au> |
---|---|
To: | "Dominic J(dot) Eidson" <sauron(at)the-infinite(dot)org>, pgsql-hackers(at)postgresql(dot)org |
Cc: | pgsql-general(at)hub(dot)org, pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef? |
Date: | 2000-09-26 12:06:52 |
Message-ID: | 00092623084900.00345@freebsd.freebsd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers pgsql-sql |
-Hello
- If you want the default value to be "0" the code for that is
default = '0'
Like so
CREATE TABLE Customer (Customer_ID INT Default = '0',
I believe this should work.
dannyh
dannyh(at)idx(dot)com(dot)au
On Mon, 25 Sep 2000, Philip Warner wrote:
> At 19:22 24/09/00 -0500, Dominic J. Eidson wrote:
> >
> >In these cases, is NULL = 0? - What if it returns the UID for "root"
> >(typically UID 0)... I think an error message should/would be better in
> >this case.
> >
>
> No NULL is NULL, a special value that usually means 'nothing found'.
>
>
> ----------------------------------------------------------------
> Philip Warner | __---_____
> Albatross Consulting Pty. Ltd. |----/ - \
> (A.B.N. 75 008 659 498) | /(@) ______---_
> Tel: (+61) 0500 83 82 81 | _________ \
> Fax: (+61) 0500 83 82 82 | ___________ |
> Http://www.rhyme.com.au | / \|
> | --________--
> PGP key available upon request, | /
> and from pgp5.ai.mit.edu:11371 |/
From | Date | Subject | |
---|---|---|---|
Next Message | Maurizio Cimaschi | 2000-09-26 12:12:49 | Re: web programming |
Previous Message | admin | 2000-09-26 11:58:47 | Int8 problem |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-09-26 14:54:10 | Reimplementing permission checks for rules |
Previous Message | devik | 2000-09-26 11:49:41 | Re: pgsql is 75 times faster with my new index scan |
From | Date | Subject | |
---|---|---|---|
Next Message | Edipo E. F. Melo | 2000-09-26 16:25:01 | date is not equals to dia/month/year: what's wrong? |
Previous Message | Karel Zak | 2000-09-26 08:02:38 | Re: Data Type precision |