Re: [SQL] Differences between bit string constant sintax

On 2009-09-09, Oliveiros C, wrote: > This is a multi-part message in MIME format. > > --=_NextPart_000_013B_01CA3146.85B62920 > Content-Type: text/plain; > charset="iso-8859-1" > Content-Transfer-Encoding: quoted-printable > > Dear All, > > I have a table which has a field that is of typ

[SQL] Trapping 'invalid input syntax for integer'

Is there a way to trap this error in plpgsql code? I have a function that accepts integer and character varying. Inside that function I need to cast that varchar to integer. Of course, sometimes that is not possible. When I run function like that, I get this errror: fidel=# select * from get_acco

Re: [SQL] Trapping 'invalid input syntax for integer'

Hi, I believe you're looking for invalid_text_representation. EXCEPTION WHEN invalid_text_representation THEN regards mk 2009/9/10 Mario Splivalo > Is there a way to trap this error in plpgsql code? > > I have a function that accepts integer and character varying. Inside > that function I nee

Re: [SQL] Trapping 'invalid input syntax for integer'

Marcin Krawczyk wrote: > Hi, I believe you're looking for invalid_text_representation. > > EXCEPTION WHEN invalid_text_representation THEN > Thnx, that is it. Mike -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql

Re: [SQL] how to: refer to select list calculations other places in the calculations.

I might do the substitution, analyse the query and hope to break it up. Can it possibly be optimal? Little, Douglas wrote: Hi Rob, Thanks for the response. Repeating the base calculation will work but the calculations are stunningly complex and long. Repeating them will undoubtly increase edi

[SQL] Encryption in the tables of a Postgres 7.3.2 database

Hi, I've a Postgres DB release 7.3.2 and some developed C++ and PHP code so as to communicate with it. Currently, the data I've in the different tables is stored with no encription at all, and I was wondering if there would be an easy way to get it encrypted without major changes in the already d

[SQL] Talend : Talend Integration Suite vs Talend Open Studio

Hi all, I have been working with Talend Open Studio for a few weeks now and would like to have your opinion. Is using Talend Integration Suite really better compared to using Talend Open Studio? On what kind of project can you not use Talend Open Studio and would be best to use Talend Integra