How about
select myschema.myfunction(SELECT ARRAY(select myid from mytable));
?
On Mon, Apr 23, 2012 at 5:29 PM, Wells Oliver wrote:
> Trying to call my function like so:
>
> select myschema.myfunction(select myid from mytable);
>
> myfunction has the signature: myfunction(integer[])
>
> myid is
Trying to call my function like so:
select myschema.myfunction(select myid from mytable);
myfunction has the signature: myfunction(integer[])
myid is an integer; I am trying to select them as an array to pass to the
function.
Where am I going wrong? Thanks!
--
Wells Oliver
wellsoli...@gmail.c
On 23/04/2012, at 19.10, A J wrote:
> In FTS, how do I search for partial substrings that don't form a English word.
> Example, in the text: 'one hundred thirty four' I want to find the records
> based on 'hun'
>
> SELECT to_tsvector('one hundred thirty four') @@ to_tsquery('hun');
> does not
A J wrote:
> In FTS, how do I search for partial substrings that don't form a
> English word.
> Example, in the text: 'one hundred thirty four' I want to find
> the records based on 'hun'
>
> SELECT to_tsvector('one hundred thirty four') @@
> to_tsquery('hun'); does not return anything.
It sou
In FTS, how do I search for partial substrings that don't form a English word.
Example, in the text: 'one hundred thirty four' I want to find the records
based on 'hun'
SELECT to_tsvector('one hundred thirty four') @@ to_tsquery('hun');
does not return anything.
Thanks.
Wells Oliver wrote:
> Is there a way to get the date that starts week 14, or 15 (etc)?
Which week numbering do you use?
http://en.wikipedia.org/wiki/Week_number#Week_numbering
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscrip
Wells Oliver, 22.04.2012 00:58:
Is there a way to get the date that starts week 14, or 15 (etc)?
Try this:
select to_date('201214', 'iyyyiw')
That uses the ISO week definition.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www