On Thursday, August 30, 2018 at 3:48:34 PM UTC-7, Joseph Kowalski wrote:
>
> As a follow up:
> I've implemented this in my code as follows:
> array_of_arrays = [[123456, Date.iso8601('2018-08-15')],
> [123457, Date.iso8601('2018-08-15')],
> [123458, Date.iso8601('2018-08-15')]]
> DB.from(Sequel[:services].as(:svcs), DB.values(array_of_arrays).
> as(:updsvcs, [:sid, :new_billed_through])).
> where{svcs[:service_id] =~ updsvcs[:sid]}.
> update( :billed_through => Sequel[:updsvcs][:new_billed_through])
>
> I'm having trouble with this however as one of the fields in my actual
> code and DB is a date field. However when it's turned into a 'value', the
> data is turned into text (I think that's when this happens) as I get the
> following error on insert:
> PG::DatatypeMismatch: ERROR: column "billed_through" is of type date but
> expression is of type text
>
> The DB logger shows the following resulting output (I've replace the
> actual data with my dummy array of arrays as above and cleaned up the
> formatting)
> E, [2018-08-30T15:39:54.660212 #24068] ERROR -- : PG::DatatypeMismatch:
> ERROR:
> column "billed_through" is of type date but expression is of type text
> LINE 1: ...PDATE "services" AS "svcs" SET "billed_through" = "updsvcs"....
> ^
> HINT: You will need to rewrite or cast the expression.:
> UPDATE "services" AS "svcs"
> SET "billed_through" = "updsvcs"."new_billed_through"
> FROM (VALUES (123456, '2018-08-15'),
> (123457, '2018-08-15'),
> (123458, '2018-08-15')) AS "updsvcs"("sid",
> "new_billed_through")
> WHERE ("svcs"."service_id" = "updsvcs"."sid")
>
> Is there a way to cast that value as a date that Postgres will accept for
> that field?
>
>
You can probably do:
Sequel[:updsvcs][:new_billed_through].cast(Date)
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
