ERROR: query has no destination for result data
HINT: If you want to discard the results of a SELECT, use PERFORM instead.
CONTEXT: PL/pgSQL function "subjectdisplay" line 7 at SQL statement
** Error **
ERROR: query has no destination for result data
SQL state: 42601
Hint: If
On 16/11/2010 21:27, Christine Penner wrote:
Select S_TRAINING_TITLE as Display from System Limit 1;
Looking again at your function, I think this (and other similar lines)
should be
select s_training_title into display
- i.e. "into" instead of "as".
HTH,
Ray.
--
Raymond O'Donnell
I am returning one value (text). Each of the selects in the function
should also return only one value.
At 02:06 PM 16/11/2010, you wrote:
On 11/16/2010 3:57 PM, Christine Penner wrote:
I have seen other functions (written by others) that do this. So I
assume its ok. I'm open to suggestions th
On 16/11/2010 21:57, Christine Penner wrote:
I have seen other functions (written by others) that do this. So I
assume its ok. I'm open to suggestions though. As long as it works.
OK, fair enough. What error are you getting?
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent
On 11/16/2010 3:57 PM, Christine Penner wrote:
I have seen other functions (written by others) that do this. So I
assume its ok. I'm open to suggestions though. As long as it works.
At 01:54 PM 16/11/2010, you wrote:
On 16/11/2010 21:27, Christine Penner wrote:
create or replace function Subj
I have seen other functions (written by others) that do this. So I
assume its ok. I'm open to suggestions though. As long as it works.
At 01:54 PM 16/11/2010, you wrote:
On 16/11/2010 21:27, Christine Penner wrote:
create or replace function SubjectDisplay(IN subj varchar,IN meetCode
numeric
On 16/11/2010 21:27, Christine Penner wrote:
create or replace function SubjectDisplay(IN subj varchar,IN meetCode
numeric,IN meetTrWP integer,OUT Display varchar)
returns varchar as
I'm not certain about this, but is it a mistake to mix OUT parameters
and RETURNS?
Ray.
--
Raymond O'Donn
I am trying to write a postgres function and I'm getting errors when
the parameter sub is empty (it wont ever be null) and meetCode has a number.
This is the function code:
create or replace function SubjectDisplay(IN subj varchar,IN meetCode
numeric,IN meetTrWP integer,OUT Display varchar)
Francis Waweru wrote:
Am creating a function that will be able to sort date from a table
that is over 400,000 rows. I want to pass variables from a java
application am running but I can't able to do so. Please help on how
to pass a variable from an application to a function so that I can
speed up
Am creating a function that will be able to sort date from a table
that is over 400,000 rows. I want to pass variables from a java
application am running but I can't able to do so. Please help on how
to pass a variable from an application to a function so that I can
speed up my select queries.
Wawe
10 matches
Mail list logo
