[SQL] CAST from VARCHAR to INT

complaining that it can't stick a VARCHAR into an INT. All the values in the column are valid integers (the foreign key sees to that) but even a CAST won't do it. How can I force it to copy/change the values? ======== Luke Pascoe Senior Developer /

Re: [SQL] CAST from VARCHAR to INT

Sweet, worked the charm, thanks! P.S. Anyone know why it takes several hours[1] for my posts to come through the list? [1] Posted a message at ~9am friday, it got back to me ~4pm! - Original Message - From: "Bhuvan A" <[EMAIL PROTECTED]> To: "Luke Pascoe" <[

[SQL] checking data integrity in a recursive table

ember that "parent" can also be NULL. Or would this be better done as a trigger? TIA! ==== Luke Pascoe KMG (NZ) Limited. http://www.kmg.co.nz Mobile: (021) 303019 Email: [EMAIL PROTECTED] --

[SQL] Inserting a tab character

I have a table which defines various possible file delimiters (CHAR(1) NOT NULL), for the moment it'll only contain comma and tab. Inserting a comma is easy, but inserting a tab is proving somewhat more difficult. How do I do it in 'psql'? Luke Pascoe. ---