work because the subquery returned more than one value. Of
course I want it to return all values, but just one per insert.
I can do this outside of Postgres, but would like to learn how to do this
with SQL.
Chuck Martin
Avondale Software
reSQL 9.3.1 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.4.7
20120313 (Red Hat 4.4.7-3), 64-bit"
What other information would help solve this?
Chuck Martin
Avondale Software
where I once lived).
Chuck Martin
Avondale Software
On Wed, May 1, 2019 at 1:52 PM Francisco Olarte
wrote:
> On Wed, May 1, 2019 at 7:37 PM Chuck Martin
> wrote:
> >
> > Something like daterange would be a solution in some circumstances, but
> this query is a user-generated
(given the
advice received here) inclined to check the value entered when searching
for a date, and if no time is entered, add '24:00' to the date.
Chuck Martin
Avondale Software
On Wed, May 1, 2019 at 1:32 PM Adrian Klaver
wrote:
> On 5/1/19 10:15 AM, Francisco Olarte wrote:
> >
;May 2, 2019'
wouldn't it? I'm not sure one is easier to implement than the other.
Chuck Martin
Avondale Software
On Wed, May 1, 2019 at 1:16 PM Francisco Olarte
wrote:
> Chuck:
>
> On Wed, May 1, 2019 at 6:56 PM Chuck Martin
> wrote:
> > Thanks, guys. It
Thanks, guys. It should have been obvious to me, but wasn't.
I found the correct result was returned with either
AND event.DateTime <= 'May-1-2019 24:00'
or
AND event.DateTime::date <= 'May-1-2019'
The latter seems best.
Chuck Martin
Avondale Software
On W
g the data
comparison correctly, but don't know why.
Chuck Martin
Avondale Software
I store them as bytea in the database despite the fact that there are
benefits to storing them in the file system. The reason is that it is
easier to secure access to the database than to secure both the database
and provide secure access to the file system.
Chuck Martin
Avondale Software
On
On Mon, Feb 18, 2019 at 12:37 PM Andrew Gierth
wrote:
> >>>>> "Chuck" == Chuck Martin writes:
>
> Chuck> I am trying to create a query that returns all transactions for
> Chuck> each person who has a balance over a given amount. I thought
> Ch
o how do I get all transactions for each case_pkey? I've read the
documentation on WITH clauses (CTEs), but that just left my head spinning.
Chuck Martin
Avondale Software
On Sun, Jan 27, 2019 at 5:27 PM Chuck Martin
wrote:
> On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote:
>
>> On 2019-01-26 18:04:23 -0500, Chuck Martin wrote:
>> [snip]
>> > The idea should be obvious, but to explain, insdatetime is set when a
>> new
&g
On Sun, Jan 27, 2019 at 8:07 AM Peter J. Holzer wrote:
> On 2019-01-26 18:04:23 -0500, Chuck Martin wrote:
> [snip]
> > The idea should be obvious, but to explain, insdatetime is set when a new
> > record is created in any table. All records in ombcase have a foreign
> k
Chuck Martin
Avondale Software
On Sun, Jan 27, 2019 at 2:55 PM Adrian Klaver
wrote:
> On 1/26/19 3:04 PM, Chuck Martin wrote:
> [snip]
> Outline form:
>
> 1) If a record is in ombcase it has a status('in a status') by definition.
>
> From query below you are
OIN status
ON status_fkey = status_pkey
AND lower(statusid) NOT LIKE ('closed%')
AND coalesce ( age(ombcase.insdatetime), age(statuschange.insdatetime) ) >
'2 months'
But this query will return all statuschange records for an ombcase record
that has multiple ones.
Any suggestio
On Thu, Jan 3, 2019 at 3:46 PM Stephen Frost wrote:
> Greetings Chuck,
>
> * Chuck Martin (clmar...@theombudsman.com) wrote:
> > Using iperf, the transfer speed between the two servers (from the main to
> > the standby) was 938 Mbits/sec. If I understand the units correctly,
s difficult to parse out since in
the real world, many more tables and columns are involved.
Chuck Martin
Avondale Software
On Mon, Dec 31, 2018 at 12:05 PM Jeff Janes wrote:
> On Sun, Dec 30, 2018 at 6:17 PM Chuck Martin
> wrote:
>
>> Maybe I need to rethink ths and take Jeff's advice. I executed this:
>>
>> pg_basebackup -h [main server's URL] -U postgres -P -v -X s -D
>>
he same GB
ethernet network.
Chuck Martin
Avondale Software
On Sun, Dec 30, 2018 at 3:28 PM Jeff Janes wrote:
> On Sat, Dec 29, 2018 at 2:05 PM Chuck Martin
> wrote:
>
>> I thought I knew how to do this, but I apparently don't. I have to set up
>> a new server as a st
On Sun, Dec 30, 2018 at 11:20 AM Peter Eisentraut <
peter.eisentr...@2ndquadrant.com> wrote:
> On 29/12/2018 20:04, Chuck Martin wrote:
> > I thought I knew how to do this, but I apparently don't. I have to set
> > up a new server as a standby for a PG 11.1 server. The
G 11
replication? Everything I find online is very old.
Chuck Martin
Avondale Software
On Thu, Dec 20, 2018 at 10:12 PM Adrian Klaver
wrote:
> On 12/20/18 5:51 PM, Chuck Martin wrote:
>
> Please reply to list also.
> Ccing list.
>
> >
> >
> > On Thu, Dec 20, 2018 at 7:56 PM Adrian Klaver > <mailto:adrian.kla...@aklaver.com>> wrote:
&
ND usr.Backup_fkey = backup.Usr_pkey
AND ombcase.Status_fkey = status.Status_pkey
AND event.InsBy::int = usr.Usr_pkey
AND event.Event_pkey = 1060071
ORDER BY EventDone, DateTime DESC
Chuck Martin
Avondale Software
22 matches
Mail list logo
