This is the Postgres definition of my method.
CREATE OR REPLACE FUNCTION ui.migrate_advertisers(
newadvertiser bigint,
childrenadvertisers bigint[])
RETURNS void
LANGUAGE 'plpgsql'
COST 100.0
VOLATILE AS $function$
.... sql code here
$function$;
When I invoke it from Java via:
public void migrationAdvertisers(long targetAdvertiser, Long[]
advertisersToBeMigrated) {
Routines.migrateAdvertisers(dslContext.configuration(),
targetAdvertiser, advertisersToBeMigrated);
}
But the code that is generated is this:
select * from ui.migrate_advertisers(newadvertiser := 3303,
childrenadvertisers :=
cast('{"11533","11545","11548","11553","4225","11558"}' as bigint[]))
I'm wondering why Jooq converts the Long to strings when invoked. I would
expect it to call.
select ui.migrate_advertisers(3303,
'{11533,11545,11548,11553,4225,11558}');
--
Thank you
Samir Faci
https://keybase.io/csgeek
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
