foo> - Search results in mailing lists
Mailing lists >> pgsql-sql >> Thread >> Search in thread (4)
2025-01-07 23:07:16 | RE: View performance with implicit cast (Tomasz Szypowski)
foo (id int); CREATE TABLE postgres=# CREATE VIEW test AS SELECT * FROM foo; CREATE VIEW
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2023-09-18 06:49:01 | RE: no_data_found oracle vs pg (Jean-Marc Voillequin (MA))
foo INTO target; GET DIAGNOSTICS rows = ROW_COUNT; IF rows <> 1 THEN /* do what you want
Mailing lists >> pgsql-sql >> Thread
2022-05-25 18:03:34 | Re: Using Transaction with if-else in prepared statement (Steve Midgley)
INSERT INTO foo VALUES($1, $2, $3, $4); EXECUTE fooplan(1, 'Hunter Valley', 't', 200.00);
Mailing lists >> pgsql-sql >> Thread
2022-04-28 13:10:02 | AW: xargs psql (Marc Mamin)
foo(\$\${}\$\$)' > ouputdir/{}.out"
HTH,
Marc Mamin
________________________________________
Von: Shaozhong SHI
Mailing lists >> pgsql-sql >> Thread
2021-11-11 14:23:57 | Re: Constructing colum name as alias (chris)
foo limit 11;
Regards,
Chris
On 11/11/2021 22:16，David G. Johnston
Mailing lists >> pgsql-sql >> Thread
2021-10-14 12:35:02 | Re: What is the regex for apostraphe in postgres? (Torsten Grust)
foo''bar' SIMILAR TO '_+''_+'; -> #t Cheers, —T On Thu, Oct 14, 2021, at 12:31, Shaozhong
Mailing lists >> pgsql-sql >> Thread
2021-01-23 21:50:10 | Re: Question about WITH ORDINALITY and unnest (Tom Lane)
foo','bar','baz']) as x(a,b); a | b ---+----- 1 | foo 2 | bar | baz (3 rows
Mailing lists >> pgsql-sql >> Thread
2020-12-18 21:03:30 | Custom aggregate last_value_when (Ben Tilly)
foo') over w as last_foo_timestamp , last_value_when(value, measurement_type = 'foo') over
Mailing lists >> pgsql-sql >> Thread
2020-08-11 14:43:04 | Re: Use multidimensional array as VALUES clause in insert (Igor Andriychuk)
foo(id int, arr text[]); truncate table foo; insert into foo values (1, '{"value1", "value2
Mailing lists >> pgsql-sql >> Thread >> Search in thread (3)
2019-07-18 08:54:28 | Re: IN vs arrays (was: Re: how to resolveorg.postgresql.util.PSQLException: ERROR: operator does (Karen Goh)
foo IN (SELECT unnest(ARRAY[1,2,3])) ; You can also combine operators with the ANY/ALL
Mailing lists >> pgsql-sql >> Thread
2019-05-19 16:20:29 | Re: Table as argument in postgres function (Pavel Stehule)
foo(regclass) returns setof record as $$ begin return query execute format('select * from %s', $1); -- cast
Mailing lists >> pgsql-sql >> Thread
2019-05-19 01:17:35 | Re: create index on a jsonb timestamp field? (Tom Lane)
foo(data jsonb, ts timestamptz GENERATED ALWAYS AS ((data->>'ts')::timestamptz) stored); psql: ERROR: generation
Mailing lists >> pgsql-sql >> Thread >> Search in thread (2)
2019-02-01 16:06:56 | Idea: INSERT INTO ... NATURAL SELECT ... (Sven Berkvens-Matthijsse)
foo, source.bar, source.beep FROM source; INSERT INTO test_table NATURAL SELECT source.foo AS b, source
Mailing lists >> pgsql-sql >> Thread
2018-08-30 00:46:02 | Stored Procedure to Delete Rows and Return Count (Dave Bolt)
foo where id=$1 RETURNING *) select count(*) $$ LANGUAGE SQL; Unfortunately this thinks that DELETE is a syntax
Mailing lists >> pgsql-sql >> Thread
2018-04-18 12:20:39 | summary view design / performance (Gary Stainburn)
foo group by sj_id; In the production environment the view will be called with