Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> writes:
> Quotes and casting together are not necessary.
Check.
> I'd choose "lid = 457::int2" since it's telling PG what the datatype
> is, whereas with lid = '457', PG must figure it out.
I'd lean to the quotes, actually, since that way your application's
code isn't so dependent on the particular datatypes in the table.
I doubt there's any performance advantage to writing the cast, if
that's what you were thinking ...
regards, tom lane