Be quiet... it is not a db problem: your shell interprets "'" characters
before sending them to psql so your query becomes
UPDATE users SET pin=12345 WHERE login=admin;
and column admin (not the literal 'admin') doesn't really exist!
Try this:
su - postgres -c "psql --dbname database --command \"
Josep Sanmartí wrote:
Hello,
I have a 'big' problem:
I have the following table users(name, start_time, end_time), a new row
is set whenever a user logs into a server. I want to know how many
users have logged in EVERYDAY between 2 different dates. The only idea
that I have is making several
on is correct one ... I will try to use oly execute
on insert,update and select on temp table MagMaxNrBon
(o_gen_calc_nr_doc is the "get_me_next_number" function)
thank you,
Adria Din
On Mon, 04 Jul 2005 17:27:20 +0200, Zac <[EMAIL PROTECTED]> wrote:
Din Adrian wrote:
solution is
to run "get_me_next_number" in the same transaction.
Another solution (not so good but should work) is to generate by
yourself the number (as you do) and lock the table until you end to
prevent others inserting documents.
I hope this helps you.
Bye
thak you,
Adi
On Mon, 04 Jul 20
Din Adrian wrote:
Hello,
I have a 'big' problem:
I am trying to run from a procedure a function witch generate a new
document number (max from table +1 ) and after to insert a document
with this number, but the function returns me the same number each time
because the tranzaction is not fin
SELECT
table.*
FROM
table
JOIN (SELECT id, count(id) AS count FROM... your subquery) AS x
ORDER BY
x.count
Bye.
Sorry: I forgot join condition:
SELECT
table.*
FROM
table
JOIN (SELECT id, count(id) AS count FROM... your subquery) AS x ON
(table.id = x.id)
ORDER BY
Riya Verghese wrote:
select * from table where id IN (2003,1342,799, 1450)
I would like the records to be ordered as 2003, 1342, 799, 1450. The
outer query has no knowledge of the count(id) that the inner_query is
ordering by.
I think this is the real problem: outer query must know count(id)
Hi.
I have this problem in a plpgsql function:
SELECT INTO myvar col FROM table WHERE ...;
IF THEN
do something
ELSE IF THEN
do something else
ELSE
do other things
If I know that myvar IS NULL OR GET DIAGNOSTICS
ROW_COUNT is zero.
Is there a way to know if the que
