Re: How to select text field as interger - Mailing list pgsql-sql

From silly sad
Subject Re: How to select text field as interger
Date
Msg-id 4C2AFC7E.2050806@bankir.ru
Whole thread Raw
In response to Re: How to select text field as interger  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
>> | SELECT Name FROM Test WHERE Name::INT = 1;
>
> But note that this is going to throw an error if there are any table
> rows where the name field *doesn't* contain a valid integer.

and it recalls the problem of error suppressing once again




pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to select text field as interger
Next
From: Eduardo Schweigert
Date:
Subject: Invitation to connect on LinkedIn