On Fri, Apr 20, 2001 at 04:58:02PM -0700, Jie Liang wrote:
>
> I 've a question about begin...end in plpgsql
> does
> sql stmts in
> begin
>
> end;
> will go one transaction?
Read the documentation (programmer's guide). It's all there. It's to
answer your questions that we take the
I 've a question about begin...end in plpgsql
does
sql stmts in
begin
end;
will go one transaction?
i.e.
begin...end have same meaning as sql stmts BEGIN...COMMIT??
if failed, transaction abort?
if select..for update is used then
another update stmt will wait on the same rows??
if begin..
Mark Stosberg wrote:
>
> Hello,
>
> I'd like to create some tables that would visible across databases,
> much like the postgres system tables. These would be for "static" data,
> such as state and country codes, and geo-spatial data. I couldn't find
> this mentioned in the docs, but unless th
Mark Stosberg <[EMAIL PROTECTED]> writes:
> I'd like to create some tables that would visible across databases,
> much like the postgres system tables. These would be for "static" data,
> such as state and country codes, and geo-spatial data. I couldn't find
> this mentioned in the docs, but unl
Hello,
I'd like to create some tables that would visible across databases,
much like the postgres system tables. These would be for "static" data,
such as state and country codes, and geo-spatial data. I couldn't find
this mentioned in the docs, but unless this feature of the system tables
is
Hi,
I have a question about 'select ... for update';
according to the docs,
clause 'for update' will lock selected rows,
I believe it should be put into a
begin;
select ... for update;
update ...;
end;
block.
however, if I use it in a plpgsql function,
do I need another pair of begin...end?
or
Lonnie Cumberland wrote:
>
> Hello All,
>
> We are developing an application that will allow our websites to talk to our
> database.
>
> In the interest of security, I am wondering if it is possible to turn off some
> of the functions in the SQL command list such that a user can only communicat
Hi.
Thanx for your help with "PSQL to Access" problem.
Mateusz Mazur
[[EMAIL PROTECTED]]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Thu, Apr 19, 2001 at 02:53:38PM -0500, Mark Stosberg wrote:
>
> Now that I've figured out that numeric is good for storing money, and
> that I can format with like this:
>
> to_char(price, '9,999,999.99') as price
>
> Then I discovered that sometimes this returns leading spaces I don't
> wan
