On Fri, May 22, 2020 at 2:09 AM David G. Johnston <
david.g.johns...@gmail.com> wrote:
> On Friday, May 22, 2020, postgann2020 s wrote:
>
>
>>
>> We are looking for a better query than "*SELECT 1 FROM
>> schema.table_name WHERE column1=structure_id1*" this query for data
>> validation.
>>
>
If
On Friday, May 22, 2020, postgann2020 s wrote:
>
> We are looking for a better query than "*SELECT 1 FROM schema.table_name
> WHERE column1=structure_id1*" this query for data validation.
>
There is no more simple a query that involve records on a single,table.
Please suggest is there any ot
Hi David,
Thanks for your feedback.
We are using the below kind of validation throughout the proc in multiple
locations and for validation we are using the below statements.
--check Data available or not for structure_id1
IF EXISTS(SELECT 1 FROM schema.table_name WHERE
column1=structure_
You should read through the and the contained linked FAQ - note especially
the concept and recommendation for “cross-posting”.
https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics
On Thursday, May 21, 2020, postgann2020 s wrote:
>
> We have multiple long procs that are havin
