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
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
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
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
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
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.
>&
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.
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