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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-fr-generale by date

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