[SQL] Token separation

2012-01-15 Thread Tim Landscheidt
Hi, I just tried to input a hexadecimal number in PostgreSQL (8.4) and was rather surprised by the result: | tim=# SELECT 0x13; | x13 | - |0 | (1 Zeile) | tim=# SELECT 0abc; | abc | - |0 | (1 Zeile) | tim=# The documentation says: | A token can be a key word, an identifier,

Re: [SQL] Token separation

2012-01-15 Thread Tom Lane
Tim Landscheidt writes: > [ "0x13" is lexed as "0" then "x13" ] > Is this behaviour really conforming to the standard? Well, it's pretty much the universal behavior of flex-based lexers, anyway. A token ends when the next character can no longer sensibly be added to it. Possibly the documentat

[SQL] Call function with dynamic schema name

2012-01-15 Thread IlGenna
Hi to everyone, I would like to use in my function (plpgsql or sql) dynamic schema name to execute query or to call other functions. For exemple in oracle is possible to excute query in this manner: SELECT * FROM &&SCHEMA_NAME..TABLE_NAME; Where I think &&SCHEMA_NAME. is a sessione variable. I

Re: [SQL] Call function with dynamic schema name

2012-01-15 Thread Pavel Stehule
Hello 2012/1/15 IlGenna : > Hi to everyone, > I would like to use in my function (plpgsql or sql) dynamic schema name to > execute query or to call other functions. > > For exemple in oracle is possible to excute query in this manner: > > > SELECT * FROM &&SCHEMA_NAME..TABLE_NAME; > > Where I thin

Re: [SQL] Call function with dynamic schema name

2012-01-15 Thread IlGenna
Can you provide me e little example plz? Thanks in advance. Alessio -- View this message in context: http://postgresql.1045698.n5.nabble.com/Call-function-with-dynamic-schema-name-tp5146721p5146739.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com. -- Sent via pgsql-sql m

Re: [SQL] Call function with dynamic schema name

2012-01-15 Thread Pavel Stehule
2012/1/15 IlGenna : > Can you provide me e little example plz? CREATE SCHEMA s1; CREATE SCHEMA s2; CREATE TABLE s1.a1(a int); CREATE TABLE s2.a1(a int); CREATE OR REPLACE FUNCTION s1.fx1() RETURNS int AS $$ BEGIN RETURN (SELECT MAX(a) FROM s1.a1); END $$ LANGUAGE plpgsql; CREATE OR REPLACE FU

[SQL] sql query problem

2012-01-15 Thread Alok Thakur
Dear All, I have two tables one contains details of user and other contains result. The details are: 1. UserTable - id, name, phone 2. result - id, question_id, user_id, status (0 or 1) I want the list like this: User Id Name Attended Failed Passed but i could not find the way to do this

Re: [SQL] sql query problem

2012-01-15 Thread Oliveiros
What does a 0 state mean? Failed? And a 1 state? Passed? Best, Oliveiros 2012/1/14 Alok Thakur > Dear All, > > I have two tables one contains details of user and other contains > result. The details are: > 1. UserTable - id, name, phone > 2. result - id, question_id, user_id, status (0 or 1) >

Re: [SQL] Call function with dynamic schema name

2012-01-15 Thread Misa Simic
You could take a look on EXECUTE command in plpgsql... Depends on concrete problem but should be very careful with dynamic SQL because of SQL injection potential risk... Kind Regards, Misa Sent from my Windows Phone From: IlGenna Sent: 15/01/2012 18:29 To: pgsql-sql@postgresql.org Subject: [SQL]

Re: [SQL] sql query problem

2012-01-15 Thread Misa Simic
It seems question is not clear... I could not determine what should be in column Attended, and based on what should define passed/failed But quick tip would be SELECT name, CASE status WHEN 1 THEN 'Passed' ELSE 'Failed' END FROM UserTable INNER JOIN result ON UserTable.id = result.user_id Sent