Saw the following question on Stack Overflow:
http://stackoverflow.com/questions/39550510/select-for-update-returns-zero-rows
One transaction updates a row with the same values, causing another transaction
to return an empty set. This is surprising as the row passes the where clause
both before
I would like to push an array at the end of an array. Like:
'{{4,5},{8,3}}' + '{3,6}' > '{{4,5},{8,3},{3,6}}'
Is there an easy way to do? (i have version "9.1.23" on my shared hosting)
Now I have written a complex function with EXECUTE command-string...
CREATE OR REPLACE FUNCTION push_2d_ar
Hi
2016-09-18 18:46 GMT+02:00 Tjibbe :
> '{{4,5},{8,3}}' + '{3,6}'
postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]];
+-+
| ?column? |
+-+
| {{4,5},{8,3},{3,6}} |
+-+
(1 row)
regards
Pavel
2016-09-18 19:12 GMT+02:00 Pavel Stehule :
> Hi
>
>
> 2016-09-18 18:46 GMT+02:00 Tjibbe :
>
>> '{{4,5},{8,3}}' + '{3,6}'
>
>
> postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]];
> +-+
> | ?column? |
> +-+
> | {{4,5},{8,3},{3,6}} |
> +--
2016-09-18 19:15 GMT+02:00 Pavel Stehule :
>
>
> 2016-09-18 19:12 GMT+02:00 Pavel Stehule :
>
>> Hi
>>
>>
>> 2016-09-18 18:46 GMT+02:00 Tjibbe :
>>
>>> '{{4,5},{8,3}}' + '{3,6}'
>>
>>
>> postgres=# select '{{4,5},{8,3}}'::int[] || ARRAY[[3,6]];
>> +-+
>> | ?column? |
Hi guys,
I've got the following query:
WITH
> accounts AS (
> SELECT
> c.id AS company_id,
> c.name_first AS c_first_name,
> c.name_last AS c_last_name,
> c.company AS c_name,
> FROM public.clients c
> WHERE id = 33412393
> ORDER BY 1 LIMIT 100
>
2016-09-19 9:18 GMT+12:00 Patrick B :
> Hi guys,
>
> I've got the following query:
>
> WITH
>> accounts AS (
>> SELECT
>> c.id AS company_id,
>> c.name_first AS c_first_name,
>> c.name_last AS c_last_name,
>> c.company AS c_name,
>> FROM public.clients c
>>
