Re: md5 hash on table row - Mailing list pgsql-general

Michael Fuhr wrote:
> test=> SELECT id, foo FROM foo;
>  id |                           foo
> ----+---------------------------------------------------------
>   1 | (1,123,"this is a test",2005-11-02,t,"\\000\\001\\002")

Perfect!  Wow, in all these years of using PostgreSQL, I did not know
you can "SELECT tablename FROM tablename".

Thanks Michael.

PS: Does anyone know if this very portable to other databases?

-Jon

--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
  Jon Lapham  <lapham@jandr.org>                Rio de Janeiro, Brasil
  Personal: http://www.jandr.org/
***-*--*----*-------*------------*--------------------*---------------