Search Postgresql Archives

Interesting abilities of substring

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux