Interesting abilities of substring

From: Kenneth Downs <ken(at)secdat(dot)com>
To: pgsql general <pgsql-general(at)postgresql(dot)org>
Subject: Interesting abilities of substring
Date: 2007-08-09 12:51:16
Message-ID: 46BB0DC4.9080507@secdat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here is something cool that I did not realize postgres's substring()
could do.

Basically, it "knows what you mean" when you do substrings on dates and
numbers, doing an implicit cast for you. This is really nice if you
happen to be writing a generalized search system, as it makes the code
significantly simpler...

That's all, now back to our regularly scheduled mailing list.

--
Kenneth Downs
Secure Data Software, Inc.
www.secdat.com www.andromeda-project.org
631-689-7200 Fax: 631-689-0527
cell: 631-379-0010

Responses

Browse pgsql-general by date

  From Date Subject
Next Message M S 2007-08-09 12:54:17 Re: failed to unlink, Permission denied
Previous Message Merlin Moncure 2007-08-09 12:19:50 Re: failed to unlink, Permission denied