2006/7/7, T E Schmitz <[EMAIL PROTECTED]>:
valid entries would be:
"28mm F2.8" (prime lens)
"30-70mm F4" (zoom lens)
"30-70mm F2.8" (zoom lens)
"30-100mm F4.5-5.6" (zoom lens with variable speed)
If these are the cases, wouldn't the regex be simply:
"^[\d\-]+mm" for BASE
"^[\d\-]+mm (.+)$" f
On Sun, Jul 09, 2006 at 09:52:35AM +0200, Luca Giandoso wrote:
> I wold like to make a plpgsql function that return column names and
> their data types of a specific table.
Do you have a reason for returning a cursor instead of SETOF some
type? In versions prior to 8.1 you could create a custom t
I need to list products from the table of ordered products with ordered
quantities. Each product should be there only once but quantity should be a
sum from all the same products from the table.
I prepared some query but in quantity column I can see only amount from
one record. I need to have su
I need to list products from the table of ordered products with ordered
quantities. Each product should be there only once but quantity should be a sum
from all the same products from the table.
I prepared some query but in quantity column I can see only amount from one
record. I need to have su
I wold like to make a plpgsql function that return column names and
their data types of a specific table.
I have done this using:
CREATE OR REPLACE FUNCTION _get_table_definition(refcursor) RETURNS
refcursor SECURITY DEFINER AS
$$
DECLARE
BEGIN
OPEN $1 FOR SELECT column_name as field_name, dat
