| From: | Dennis Gearon <gearond(at)cvc(dot)net> |
|---|---|
| To: | Robert Treat <xzilla(at)users(dot)sourceforge(dot)net> |
| Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: [SQL] rewriting values with before trigger |
| Date: | 2003-04-24 19:35:49 |
| Message-ID: | 3EA83C95.8070404@cvc.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
Well,
does ''::INT do anything valuable?
change column to a string, convert to INTS on the way out, STRINGS on the way in?
use an external language to make transitions.
Robert Treat wrote:
> On Thu, 2003-04-24 at 15:10, Dennis Gearon wrote:
>
>>I have no idea how the transport of a value of '' happens in the parser if it's expecing a NULL/INT value, if it would even make it to the trigger stage <shrug>.
>>
>
>
> :-) Thats the problem, it doesn't.
>
> Robert Treat
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dennis Gearon | 2003-04-24 19:37:31 | Re: ODBC & Access [Try 2] |
| Previous Message | Andrew Sullivan | 2003-04-24 19:35:25 | Re: > 16TB worth of data question |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Treat | 2003-04-24 19:49:05 | Re: [SQL] rewriting values with before trigger |
| Previous Message | Robert Treat | 2003-04-24 19:22:24 | Re: [SQL] rewriting values with before trigger |