select * become select count(*) or what ?

[aik2]

Hello All !

Sending query to postgresql like:
select * from MY_FUNCTION(1,2)
and get an error in log:
"error relation "MY_FUNCTION" does not exist"
"STATEMENT select count(*) from "MY_FUNCTION"

Running under Delphi6, dbExpress, postgresql 8...

Running query under pgAdminIII ok.
Running other queries from Deplhi ok.

Please advise,
Ilya

 

[feherke]

Hi

You did not gave enough details about your function, but I think you simply need :

[b]select[/b] MY_FUNCTION(1,2);

Feherke.

http://rootshell.be/~feherke/

 

[aik2]

Hello! This a test sample:

CREATE TABLE _testdbf (fooid int, foosubid int, fooname text);
INSERT INTO _testdbf VALUES (1, 1, 'Joe');
INSERT INTO _testdbf VALUES (1, 2, 'Ed');
INSERT INTO _testdbf VALUES (2, 1, 'Mary');


CREATE FUNCTION _test(int,int,int,int) RETURNS SETOF _testdbf AS $$
SELECT * FROM _testdbf;
$$ LANGUAGE SQL;

Runs at pgAdmin3 correct.

Run under application and get a message:

relation "test" does not exist
STATEMENT: select count(*) from "_test"

I didn't really sure that it's problem of peostgresql, but I doubt that standart Delphi component joke on me .

 

[aik2]

Thank you for help.

I find an error and this was a Delphi's component problem

 

[feherke]

Hi

Got it. Tried it. Works for me. ( I used Kylix 2 with dbExpress and PostgreSQL 7.3.3. )

After a couple of years of experience I usually blame dbExpress by default for all stupid behaviors.

Feherke.

http://rootshell.be/~feherke/