Dear Marcin
Thanks for your reply.
My created function running well as exposed by you in ttt() function
and this is no problem.
I need extend this query.
See:
TableA
prod_idnumeric(10)
prod_name varchar(40)
...
My function, as your ttt(), return 3 values and value prod_id from
TableA m
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Paulo Nievierowski wrote:
| PS: Excuses my poor english.
Your english is excellent. MY is poor!!
| I create plpgsql function "myfunc(integer)" thats returns of type
| record with values from table X (the function decides what record must
| be select). T
Hello,
This is my first message to pgsql-novice.
I create plpgsql function "myfunc(integer)" thats returns of type
record with values from table X (the function decides what record must
be select). The parameter is an keyprod existing in table X and in
table A.
It run well sending in psql:
SELEC
Hi,
I have a table with FQDN. I'm trying to take from it the second part which
desribed a city. Query isn't too clear but with what is important that
whole substr was counted once and applied to every row. Can I (how?) force
executor to run this substr on every row of my table?
mtldb=# select sub
