Is it possible?
Thank you!
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hi,
According to the following report, I think using "except" would be the best
way to do. Thank you!
Jack
EXPLAIN
SELECT DISTINCT a.c1
FROM test_j2 a
WHERE a.c1 NOT IN (SELECT DISTINCT b.c1 FROM test_j1 b);
Unique (cost=54544.91..54547.41 rows=50 width=6)
-> Sort
On Tue, Mar 18, 2003 at 03:47:55PM +0100, alexj wrote:
> Hi,
>
> I'm looking how can I do to insert multiple values from a
> complexe query.
>
> What I want to do is something like that :
>
> INSERT INTO est_planifie_jour (id,ref_activite,ref_ressource,ref_jour)
> (SELECT nextval('est_p_id_p')
On Wednesday March 19 2003 9:18, [EMAIL PROTECTED] wrote:
>
> What I want to be able to do is make sure that at all times the child
> records linked to a parent record have values for the "rank" field that
> are consecutive starting at 1, ie (1,2,4,5,6) not (1,2,4,5,7).
>
> Can someone offer the be
hello,
I was hoping someone might be able to help me with this problem...
I have a table that is essentially joined back to a parent table. I have a
column in the child table called "rank" that is a simple integer data type, used
to indicate the order that the child elements should be displayed
"Victor Yegorov" <[EMAIL PROTECTED]> writes:
> May be I'll put my question in a different manner:
> System tables are location-wide (I mean one set of tables for PostgreSQL
> location) or each database has it's own set of system tables?
pg_database, pg_shadow, pg_group are shared, the rest are pe
"Victor Yegorov" <[EMAIL PROTECTED]> writes:
> I'd like to make a script to automatically vacuum all my DBs nightly. And
> I'd like to skip system tables, starting with pg_*.
Um ... what in the world makes you think that's a good idea? System
tables need maintenance too.
> My postings seem to double on me.
It's standard procedure to reply twice, one to the list
and one to the sender, because you don't need to
subscribe to the list to get the answers. But if you are
subscribed and ask a question you usually get two.
>
> Now this works. So going to the next questio
> I'd like to make a script to automatically vacuum all my DBs nightly. And
> I'd like to skip system tables, starting with pg_*.
If you run the process as non-super user, it must skip your system tables.
On the other hand, if you run it as a super user, it must be done table
wise from your scr
Hi,
My postings seem to double on me. Well thanks
to everybody that answered. They were not the answers I was hoping for
but, I found one in the docs. Let me explain again what I'm doing with a
example:
table:
points id
distance
1
25 0.26598333
1
32
On Wed, 19 Mar 2003, Kyle wrote:
> What is the SQL command to list users?
>
> CREATE USER, DROP USER, ALTER USER, USER
>
> I just can't seem to find the command to list them.
SELECT * from pg_user ;
>
> -Kyle
>
>
> ---(end of broadcast)---
What is the SQL command to list users?
CREATE USER, DROP USER, ALTER USER, USER
I just can't seem to find the command to list them.
-Kyle
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
>
> Hi all.
> Recently I face some problem with casting character type variable and
> varchar variable.
> The situation was like: I had 2 table, on table A, the user_name is
defined
> as character(32), and table B uses varchar(32). I have 1 function and
a
> trigger to manipulate with these data.
>
Hello.
I'd like to make a script to automatically vacuum all my DBs nightly. And
I'd like to skip system tables, starting with pg_*.
I've seen in the list archives somebody's solution using regexps,
something like:
$> vacuum analyze !~ ^pg_;
It doesn't work for me, and I cannot find the origin
Uz.ytkownik David Witham napisa?:
Hi,
Is there a way of capturing how many rows a select, delete or update affect from within a PL/pgSQL function?
Read Postgres documentation.
19.5.5. Obtaining result status
GET DIAGNOSTICS var_integer = ROW_COUNT;
Regards,
Tomasz Myrta
--
15 matches
Mail list logo
