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

Comment faire un cast de varchar en integer?

From: Pierre Couderc <pierre(at)couderc(dot)cc>
To: pgsql-fr-generale(at)postgresql(dot)org
Subject: Comment faire un cast de varchar en integer?
Date: 2006-04-11 08:28:09
Message-ID: e1fpaq$vvr$1@sea.gmane.org (view raw or flat)
Thread:
Lists: pgsql-fr-generale
Je chreche à convertir bêtement mon code postral qui est déclaré en 
varchar en entier?

SELECT  "Nom","Adresse","Code Postal"  FROM "Entreprises" WHERE 
CAST("Code Postal" AS INTEGER)/1000=12;

Mais il me le refuuse absolument.

Y-a-t-il une asctuce?

Pierre Couderc


Responses

pgsql-fr-generale by date

Next:From: Jean-Paul ArgudoDate: 2006-04-11 08:54:55
Subject: Re: Comment faire un cast de varchar en integer?
Previous:From: dforumsDate: 2006-04-10 14:25:43
Subject: array search

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