Breaking News: Grepper is joining You.com. Read the official announcement!

postgres sql if statement and return value

DreamCoder answered on February 10, 2023 Popularity 1/10 Helpfulness 1/10

answer postgres sql if statement and return value

related postgres sql if statement and return value

postgres sql if statement and return value

Comment

CREATE TABLE foo (fooid INT, foosubid INT, fooname TEXT);
INSERT INTO foo VALUES (1, 2, 'three');
INSERT INTO foo VALUES (4, 5, 'six');

CREATE OR REPLACE FUNCTION get_all_foo() RETURNS SETOF foo AS
$BODY$
DECLARE
    r foo%rowtype;
BEGIN
    FOR r IN
        SELECT * FROM foo WHERE fooid > 0
    LOOP
        -- can do some processing here
        RETURN NEXT r; -- return current row of SELECT
    END LOOP;
    RETURN;
END;
$BODY$
LANGUAGE plpgsql;

SELECT * FROM get_all_foo();

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: if-statement return-value sql

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

Closely Related Answers

postgres sql if statement and return value

Comment

CREATE FUNCTION get_available_flightid(date) RETURNS SETOF integer AS
$BODY$
BEGIN
    RETURN QUERY SELECT flightid
                   FROM flight
                  WHERE flightdate >= $1
                    AND flightdate < ($1 + 1);

    -- Since execution is not finished, we can check whether rows were returned
    -- and raise exception if not.
    IF NOT FOUND THEN
        RAISE EXCEPTION 'No flight at %.', $1;
    END IF;

    RETURN;
 END;
$BODY$
LANGUAGE plpgsql;

-- Returns available flights or raises exception if there are no
-- available flights.
SELECT * FROM get_available_flightid(CURRENT_DATE);

Popularity 5/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: if-statement sql return-value

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

RETURN NEXT expression;
RETURN QUERY query;
RETURN QUERY EXECUTE command-string [ USING expression [, ... ] ];

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: if-statement return-value sql

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

-- functions returning a scalar type
RETURN 1 + 2;
RETURN scalar_var;

-- functions returning a composite type
RETURN composite_type_var;
RETURN (1, 2, 'three'::text);  -- must cast columns to correct types

Popularity 2/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: sql if-statement return-value

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

CREATE PROCEDURE triple(INOUT x int)
LANGUAGE plpgsql
AS $$
BEGIN
    x := x * 3;
END;
$$;

DO $$
DECLARE myvar int := 5;
BEGIN
  CALL triple(myvar);
  RAISE NOTICE 'myvar = %', myvar;  -- prints 15
END;
$$;

Popularity 3/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: sql return-value if-statement

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

create function getf() returns int as $$
begin
  select count(*) from (
    SELECT datname FROM pg_database
  ) as result_count;

  IF result_count > 0 THEN
    return 1;
  else 
    return 0;
  end if;
end; $$ language plpgsql;

Popularity 2/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: sql if-statement return-value

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

IF v_user_id <> 0 THEN
    UPDATE users SET email = v_email WHERE user_id = v_user_id;
END IF;

Popularity 2/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: return-value if-statement sql

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

IF parentid IS NULL OR parentid = ''
THEN
    RETURN fullname;
ELSE
    RETURN hp_true_filename(parentid) || '/' || fullname;
END IF;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: if-statement return-value sql

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

IF boolean-expression THEN
    statements
[ ELSIF boolean-expression THEN
    statements
[ ELSIF boolean-expression THEN
    statements
    ...
]
]
[ ELSE
    statements ]
END IF;

Popularity 2/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: if-statement return-value sql

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Comment

CREATE OR REPLACE FUNCTION outer_func() RETURNS integer AS $$
BEGIN
  RETURN inner_func();
END;
$$ LANGUAGE plpgsql;

CREATE OR REPLACE FUNCTION inner_func() RETURNS integer AS $$
DECLARE
  stack text;
BEGIN
  GET DIAGNOSTICS stack = PG_CONTEXT;
  RAISE NOTICE E'--- Call Stack ---\n%', stack;
  RETURN 1;
END;
$$ LANGUAGE plpgsql;

SELECT outer_func();

NOTICE:  --- Call Stack ---
PL/pgSQL function inner_func() line 5 at GET DIAGNOSTICS
PL/pgSQL function outer_func() line 3 at RETURN
CONTEXT:  PL/pgSQL function outer_func() line 3 at RETURN
 outer_func
 ------------
           1
(1 row)

Popularity 2/10 Helpfulness 1/10 Language sql

Source: www.postgresql.org

Tags: if-statement sql return-value

Link to this answer
Share Copy Link

Contributed on Feb 10 2023

DreamCoder

0 Answers Avg Quality 2/10

postgres sql if statement and return value

Contents

More Related Answers

postgres sql if statement and return value

Closely Related Answers

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

postgres sql if statement and return value

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.