Re: count(*) vs count(id)

2021-02-01 Thread aNullValue (Drew Stemen)
At 2021-02-01T20:14:04-05:00, Matt Zagrabelny sent: > select count(id) from call_records where id is null; > count > ═══ > 0 > (1 row) > > Time: 0.673 ms > > Which field is count(*) counting if it is counting nulls? > > -m What you're overlooking is that, at least to my reading of y

Re: Need another set of eyes on this

2021-01-25 Thread aNullValue (Drew Stemen)
At 2021-01-25T14:17:42-05:00, James B. Byrne sent: > postgres : STATEMENT: INSERT INTO public.stock( > stock_num, manu_code, description, unit_price, unit, unit_descr) > VALUES (3, "SHM", "aluminum Bat", 180.00, "case", "12/case"); > postgres : ERROR: 42703: column "S

Re: Like Query help

2021-01-14 Thread aNullValue (Drew Stemen)
At 2021-01-14T19:27:23-05:00, Bret Stern sent: > query > > select company_code, item_code, item_description, product_line, > udf_item_width, udf_item_length, sales_unit_measure, ''as mat_type from > mas_combined_item_master where company_code='BUR' or company_code='SNJ' > or company_code='EBC

Re: Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread aNullValue (Drew Stemen)
UTC and the desired time zone, then > convert to that time zone when needed? > > Also, what programming language outside of SQL are you using (if any)? > > Greg S. > > > On Sep 27, 2020, at 5:39 PM, aNullValue (Drew Stemen) > > wrote: > > > > At

Re: Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread aNullValue (Drew Stemen)
At 2020-09-27T19:36:34-04:00, Tom Lane sent: > "aNullValue (Drew Stemen)" writes: > > What I need is for the ability to return a timestamp with timezone, using > > the UTC offset that corresponds to a column-defined timezone, irrespective > > of the client/sess

Re: Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread aNullValue (Drew Stemen)
At 2020-09-27T19:13:09-04:00, Ron sent: > On 9/27/20 4:16 PM, aNullValue (Drew Stemen) wrote: > >> Hello, >> >> I've attempted to obtain help with this problem from several other places, >> but numerous individuals recommended I ask this mailing list. >&

Re: Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread aNullValue (Drew Stemen)
At 2020-09-27T18:31:49-04:00, Adrian Klaver sent: > On 9/27/20 2:16 PM, aNullValue (Drew Stemen) wrote: > > Hello, > > > > I've attempted to obtain help with this problem from several other > > places, but numerous individuals recommended I ask this mailing list.

Returning timestamp with timezone at specified timezone irrespective of client timezone

2020-09-27 Thread aNullValue (Drew Stemen)
Hello, I've attempted to obtain help with this problem from several other places, but numerous individuals recommended I ask this mailing list. What I need is for the ability to return a timestamp with timezone, using the UTC offset that corresponds to a column-defined timezone, irrespective of