| From: | Patrick Robin <Patrick(dot)Robin(at)disney(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | backend dies when a user defined type returns null |
| Date: | 2000-11-22 00:37:34 |
| Message-ID: | 3A1B154E.F3D1EF75@fa.disney.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I created myself a user defined type following the example in the
Postgres programmer's guide.
In the example in chapter 5 it shows that the input function for the
user defined type returns null when the input type doesn't match the
correct format.
I do that for input strings that don't match my strict n.n.n format ( ex
3.2.1) but it causes the backend to die.
For example, this query causes it to die:
select * from collections where version='3.2'
But this one works because it is in the correct format:
select * from collections where version='3.2.1'
Am I doing something wrong?
Thanks
Patrick
--
________________________________________
Patrick Robin
patrickr(at)fa(dot)disney(dot)com
Walt Disney Feature Animation
500 South Buena Vista Street
Burbank,California 91521-4817
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2000-11-22 04:58:55 | Re: Transaction, Rollback and Database Corruption question, |
| Previous Message | Tom Lane | 2000-11-22 00:16:59 | Re: Core dumps, i.e. how to track down a problem |