Interesting abilities of substring - Mailing list pgsql-general

From Kenneth Downs
Subject Interesting abilities of substring
Date
Msg-id 46BB0DC4.9080507@secdat.com
Whole thread Raw
Responses Re: Interesting abilities of substring  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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


pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: failed to unlink, Permission denied
Next
From: M S
Date:
Subject: Re: failed to unlink, Permission denied