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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org/

Reply via email to