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

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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: Tue, 11 Apr 2006 10:28:09 +0200
  • Message-id: <e1fpaq$vvr$1(at)sea(dot)gmane(dot)org>
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
Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group