Skip site navigation (1) Skip section navigation (2)

Re: How to select text field as interger

From: silly sad <sad(at)bankir(dot)ru>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: How to select text field as interger
Date: 2010-06-30 08:12:46
Message-ID: 4C2AFC7E.2050806@bankir.ru (view raw or flat)
Thread:
Lists: 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



In response to

pgsql-sql by date

Next:From: Eduardo SchweigertDate: 2010-06-30 17:13:22
Subject: Invitation to connect on LinkedIn
Previous:From: Tom LaneDate: 2010-06-29 22:07:08
Subject: Re: How to select text field as interger

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group