pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: José Soares <jose@sferacarta.com>
To: vikrant@chemquick.com
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Mail about typecast
Date: Tue, 15 Jun 1999 14:42:03 +0200
Message-ID: <37664A1B.D0BF946@sferacarta.com> (raw)
References: <3765C5B3.C05DC56D@chemquick.com>



Vikrant Rathore ha scritto:

> Dear friends,
>
>     I want to run a query :
>
> vikrant=> select date_part('epoch','12 hours'::timespan)::float4;
> It returns a error message
> ERROR:  function dtof(float8) does not exist
>
> But i want to use typecast since the result of this query will be used
> to update a field of type float4.
>
> I have checked the pg_proc system table it has a function dtof with
> float8 as argument i have checked the list of functions also and
> 'dtof(float8)' is shown in that list also.
> can anyone solve this problem. I can solve the problem by using a c
> program but i want to know when the function dtof(float8) is there in
> pg_proc table then why it is not doing a typecasting.
> Thanks in advance for your kind suggestion.
>
> Thanks & regards,
> Vikrant.

Which version of PostgreSQL are you using?
This works for me. (v6.5)

hygea=> \df dtof
result|function|arguments|description
------+--------+---------+------------------------
float4|dtof    |float8   |convert float8 to float4
(1 row)

hygea=> select date_part('epoch','12 hours'::timespan)::float4;
float4
------
 43200
(1 row)

hygea=> select date_part('epoch','12 hours'::timespan);
date_part
---------
    43200
(1 row)

______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'

view thread (2+ messages)

Message-ID: <37664A1B.D0BF946@sferacarta.com>
Permalink:  ../37664A1B.D0BF946@sferacarta.com/
Also on:    postgresql.org/message-id/37664A1B.D0BF946@sferacarta.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: jose@sferacarta.com, vikrant@chemquick.com, pgsql-sql@postgresql.org
  Subject: Re: [SQL] Mail about typecast
  In-Reply-To: <37664A1B.D0BF946@sferacarta.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox