Thanks for the clarification Tom.
I have one more query.
Is there a way to get the error number for the last Transact-SQL
statement executed in a Function in postgresql?
In MSSQL Stored Procedures we used @@ERROR variable to get the same. Is
there an equivalent in postgresql functions?
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Monday, February 23, 2004 8:59 AM
To: Sumita Biswas
Subject: Re: Postgres DB
"Sumita Biswas" <sbiswas(at)cisco(dot)com> writes:
> But when I type the command "psql" and don't specify a DB name, it
> psql: FATAL: Database "postgres" does not exist in the system
Yes, because psql's default behavior is to try to connect to the DB with
the same name as your user name. That doesn't mean that such a DB is
guaranteed to exist, or even that anything is going to try to create it
for you. It's just a default behavior that people have found handy.
regards, tom lane
In response to
pgsql-sql by date
|Next:||From: Christopher Browne||Date: 2004-02-23 04:07:13|
|Subject: Re: User defined types -- Social Security number...|
|Previous:||From: Tom Lane||Date: 2004-02-23 03:29:08|
|Subject: Re: Postgres DB |