Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id D3D869FB2B3 for ; Fri, 2 Feb 2007 14:11:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 81043-10 for ; Fri, 2 Feb 2007 14:11:26 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by postgresql.org (Postfix) with ESMTP id 38C489FA410 for ; Fri, 2 Feb 2007 14:11:24 -0400 (AST) Received: by ug-out-1314.google.com with SMTP id k3so739263ugf for ; Fri, 02 Feb 2007 10:11:22 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=rSBhxpwOVsu+NiYwyWIA2P+4M5zGrwinN2ZE0vpTtd7291pmHEdwpL3lEvFd95NqVnpuYgrrxDXE1fTiokRaPHR/r355b/qgKnMwZ3XpP3JA/CadMhAprpIVIRrAnIqcJIh/VhrqCWgEGv2mb2eJwOoz8CLs5XKKLI0yj/v1aAY= Received: by 10.66.221.6 with SMTP id t6mr4753761ugg.1170439882476; Fri, 02 Feb 2007 10:11:22 -0800 (PST) Received: by 10.66.217.13 with HTTP; Fri, 2 Feb 2007 10:11:22 -0800 (PST) Message-ID: <55c095e90702021011t3d0fa1e1vb0c0e56d62b3a1de@mail.gmail.com> Date: Fri, 2 Feb 2007 16:11:22 -0200 From: "Ezequias Rodrigues da Rocha" To: pgsql-sql@postgresql.org Subject: to_chat(bigint) MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25731_25298534.1170439882446" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/21 X-Sequence-Number: 27355 ------=_Part_25731_25298534.1170439882446 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list, Now I noticed that it is impossible to convert a bigint field to char with the function to_char. Is it correct ? If not please tell me how to convert a bigint using to_char. --=20 =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D Atenciosamente (Sincerely) Ezequias Rodrigues da Rocha =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D- A pior das democracias ainda =E9 melhor do que a melhor das ditaduras The worst of democracies is still better than the better of dictatorships http://ezequiasrocha.blogspot.com/ ------=_Part_25731_25298534.1170439882446 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi list,

Now I noticed that it is impossible to convert a bigint fie= ld to char with the function to_char. Is it correct ?

If not please = tell me how to convert a bigint using to_char.

--
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D
  =             &nb= sp;            =        Atenciosamente (Sincerely)
&nb= sp;            =            Ezequias = Rodrigues da Rocha
=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-= =3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D-=3D= -=3D-=3D-=3D-=3D-
A pior das democracias ainda =E9 melhor do que a melhor das ditadurasThe worst of democracies is still better than the better of dictatorships=
http://ezequiasrocha.blo= gspot.com/ ------=_Part_25731_25298534.1170439882446--