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
Hi Team,
Thanks for your support.
Could you please suggest on below query.
We have multiple long procs that are having 100s of data validations and
currently we have written as below.
***
if (SELECT 1 FROM SCHEMA.TABLE WHERE column=data AND column=data) then
statements
etc..
*
