| From: | "Wm(dot) G(dot) Urquhart" <wgu(at)wurquhart(dot)co(dot)uk> |
|---|---|
| To: | Mike Mascari <mascarm(at)mascari(dot)com> |
| Cc: | PostgreSQL General Forum <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Violation of NOT NULL |
| Date: | 2002-05-23 15:19:25 |
| Message-ID: | Pine.LNX.4.44.0205231605330.16744-100000@mailer.wurquhart.co.uk |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 23 May 2002, Mike Mascari wrote:
<snip/>
> Also, if by chance you are coming over from Oracle and expect an empty
> string to be treated as NULL, it is not...
>
> Mike Mascari
> mascarm(at)mascari(dot)com
>
Well I have a few years of Oracle behind me and it has to said I was
working on that assumption.
With that said if '' does != NULL then what does? Just NULL? In my book
NULL means undefined and IMHO you can't get more undefined than ''!
I called my stored function passing NULL as a parameter and sure enough
the error was raised. So, what I'm going to have to do now is add code to
either the C++ application or within the script to trap empty $.
Oh well.
--
Regards,
Wm. G. Urquhart
Custom Software Solutions
http://www.wurquhart.co.uk
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Darley | 2002-05-23 15:23:30 | Re: Process balancing on smp db server/apache web server |
| Previous Message | Doug McNaught | 2002-05-23 15:18:53 | Re: Process balancing on smp db server/apache web server |