On Nov 23, 2005, at 10:45 AM, Alvaro Herrera wrote:
A. R. Van Hook wrote:
It seems that in 8.1.0 we can no longer set the SYSID when adding
users
and groups.
i.e
template1=# create role hooker sysid 1345;
NOTICE: SYSID can no longer be specified
I have lots of code that depends on the actu
David Pradier <[EMAIL PROTECTED]> writes:
> But what I couldn't find is if there is an order of precedence between
> AND and OR, that is if the AND expression is calculated before the OR
> one, or anyelse way.
AND first; see
http://www.postgresql.org/docs/8.1/static/sql-syntax.html#SQL-PRECEDENCE
Hi everybody,
during the code inspection due to our migration to 8.1,
I found a piece of SQL code written like this :
WHERE a AND b OR c AND d
Now, I know that AND and OR are commutative because it's written in the
docs.
But what I couldn't find is if there is an order of precedence between
AND
"Ken Winter" <[EMAIL PROTECTED]> writes:
> In PL/pgSQL, is there a way to put a *variable* column-name in a dot
> notation reference to a RECORD column?
No. Some of the other, less-strongly-typed PLs can do it.
regards, tom lane
---(end of broadca
(Sorry for the redundancy –
I sent this query earlier but forgot to put a title on it. Seems like it
would be more useful with a title, so here it is again. If there’s
a moderator who can delete my earlier message, please do so.)
In PL/pgSQL, is there a way
to put a *variable* column-
Hi all,
I just saw in the documentation the LISTEN/NOTIFY commands but i don't
understand how i can use them.
Can someone show me an example in PLPGSQL that use this system ?
=> A process send a NOTIFY command and a LISTEN process execute his own
commands.
Hope this clear, thanks
Steff
--
Forget about this post, i hadn't well understand what i can do with this
system,
now i find an example in the 8.0 doc with libpq that show me how it works
Sorry
THX
Steff
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please se
Bath, David wrote on 24.11.2005 23:57:
While I can happily create rules on views to allow inserts, updates
and deletes, I can't find a GUI front-end that understands that the
view allows record edits that I can run on linux (whether through X
or web-based doesn't matter) and simply open the relat
On Thu, Nov 24, 2005 at 07:43:28PM +0100, Mauricio Fernandez A. wrote:
> Is it necesary the statistics be enabled when I create indexes or to
> use them?
Uh, yes, but you can't turn them off. I suspect I don't understand
your question. Do you mean the "runtime statistics" section of the
configur
