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: Shawn <postgres(at)xmtservices(dot)net>
  • To: 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 23:41:38 +0000
  • Message-id: <200803262341.38648.postgres@xmtservices.net> <text/plain>
On Wednesday 26 March 2008 23:12:07 Rodrigo E. De León Plicet wrote:
> 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;

Perfect! Great!  Thank you!

There are so many things about SQL I don't know....

Shawn
Home | Main Index | Thread Index

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