Re: Re: [HACKERS] RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?

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 |/

In response to

Browse pgsql-general by date

  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

Browse pgsql-hackers by date

  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

Browse pgsql-sql by date

  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