User Tools

Site Tools


podoc:get_image_path_sql_function

Database Function Description of "get_image_path"

Name

get_image_path

Description

Purpose

Schema

CREATE OR REPLACE FUNCTION get_image_path(INT, INT) RETURNS text AS '
  SELECT path
           FROM files
          WHERE version = $1 
            AND size = $2;
' LANGUAGE 'sql';

History

Used first

Version 2.34

Used last

Still in use

Change history

= Version 2.34 =

CREATE OR REPLACE FUNCTION get_image_path(INT, INT) RETURNS text AS '
  SELECT path
           FROM files
          WHERE version = $1 
            AND size = $2;
' LANGUAGE 'sql';
podoc/get_image_path_sql_function.txt · Last modified: 2007/10/19 15:06 by Luud