Re: [SQL] User defined types -- Social Security number...

2004-02-22 Thread Josh Berkus
Greg, Anyone have a good pre-built user-defined type definition for creating / maintaining / manipulating a SSN ... where valid chars are in the range 000-00- through 999-99-. Actually, the range is more narrowly defined than that. I'm not sure of the exact rules, but you will never

Re: [SQL] Compiling pl/pgsql functions

2004-02-22 Thread Josh Berkus
Rod, This is another one of those items where it would be nice if users didn't need access to read the system tables, but instead could rely on the information schema (with extensions) to see what they own or have access to use -- but nothing else. Hmmm, that is a good question: can I, as a

Re: [SQL] Postgres DB

2004-02-22 Thread Tom Lane
Sumita Biswas [EMAIL PROTECTED] writes: But when I type the command psql and don't specify a DB name, it says that: psql: FATAL: Database postgres does not exist in the system catalog. Yes, because psql's default behavior is to try to connect to the DB with the same name as your user name.