Hi List,
Note beforehand: this question is a result of a stack-exchange that can be
seen here:
http://stackoverflow.com/questions/39624241/inconsistent-behaviour-of-set-returning-functions-in-sub-query-with-random
I'm often using the WHERE clause random() > 0.5 to pick a random subset of
my data.
stackexchange.
thanks,
Tom
On Mon, 26 Sep 2016 at 21:38 Tom Lane wrote:
> Tom van Tilburg writes:
> > I'm often using the WHERE clause random() > 0.5 to pick a random subset
> of
> > my data. Now I noticed that when using a set-returning function in a
> > sub-q
I am trying to build an extension where there is the need to insert large
strings consisting of javascript code. The easiest way to get these string
currently into a table is by using
\set varname `cat mycode.js`
INSERT INTO mytable VALUES (:'varname');
and run this from the psql client.
psql wil
, Tom Lane wrote:
> Tom van Tilburg writes:
> > I am trying to build an extension where there is the need to insert large
> > strings consisting of javascript code.
> > ...
> > What would be a proper way to get this code into a table via an
> extension?
> &g
You are right! I totally forgot about this dollar quoting :)
Typically one of those things you will only remember the hard way ;-)
Thanks a lot,
Tom
On Wed, Jul 5, 2017 at 5:08 PM, Tom Lane wrote:
> Tom van Tilburg writes:
> > I think I misunderstand. How would that help my insert
