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 archives
  Advanced Search

Re: FW: Re: Part 1 of several - Converting a varchar to an interval


  • From: "Rodrigo E. De León Plicet" <rdeleonp(at)gmail(dot)com>
  • To: Shawn <postgres(at)xmtservices(dot)net>
  • Cc: pgsql-sql(at)postgresql(dot)org
  • Subject: Re: FW: Re: Part 1 of several - Converting a varchar to an interval
  • Date: Wed, 26 Mar 2008 18:12:07 -0500
  • Message-id: <a55915760803261612n16a87064y6abca46a0cdc42f8@mail.gmail.com> <text/plain>

On Wed, Mar 26, 2008 at 5:45 PM, Shawn <postgres(at)xmtservices(dot)net> wrote:
>  obviously it doesn't like the extra single quotes around the 1 msec.  Any
>  suggestions for a work around?

Use dollar quoting, e.g.:

create or replace function dur_interval_msec(int) returns interval
as
$$
select ($1 * interval '1 msec');
$$
language sql
immutable
returns null on null input;



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group