Re: [GENERAL] rewriting values with before trigger - Mailing list 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
wouldeven 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
>