Re: [SQL] Suggestion: md5/crypt functions in sql

2002-10-06 Thread Dan Langille
On Sun, 6 Oct 2002, Joe Conway wrote: > Aasmund Midttun Godal wrote: > > It would be very usefull to have these in sql, so that it is even easier to create >tables with encrypted passwords. > > > > See contrib/pgcrypto See also http://www.freebsddiary.org/postgresql-7.2.php which shows how I in

Re: [SQL] Suggestion: md5/crypt functions in sql

2002-10-06 Thread Joe Conway
Aasmund Midttun Godal wrote: > It would be very usefull to have these in sql, so that it is even easier to create >tables with encrypted passwords. > See contrib/pgcrypto Joe ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [SQL] problem with subqueries

2002-10-06 Thread Stephan Szabo
On Sun, 6 Oct 2002 [EMAIL PROTECTED] wrote: > Hi guys. Thanks for the rapid replies so far. > > To answer some of the questions: > > >you did not indicate an explicit join - or even a "from" clause for that > >matter- in the example of your create view statement. > > My original post was a simpl

[SQL] Suggestion: md5/crypt functions in sql

2002-10-06 Thread Aasmund Midttun Godal
It would be very usefull to have these in sql, so that it is even easier to create tables with encrypted passwords. Regards, Aasmund Midttun Godal [EMAIL PROTECTED] - http://www.godal.com/ +47 40 45 20 46 ---(end of broadcast)--- TIP 4: Don't 'k

Re: [SQL] problem with subqueries

2002-10-06 Thread pete
Hi guys. Thanks for the rapid replies so far. To answer some of the questions: >you did not indicate an explicit join - or even a "from" clause for that >matter- in the example of your create view statement. My original post was a simplified version. Here is the actual view creating statement: