tagged [exists]
PL/pgSQL checking if a row exists
PL/pgSQL checking if a row exists I'm writing a function in PL/pgSQL, and I'm looking for the simplest way to check if a row exists. Right now I'm SELECTing an `integer` into a `boolean`, which doesn'...
- Modified
- 1 Sep at 19:3
SQL Server: IF EXISTS ; ELSE
SQL Server: IF EXISTS ; ELSE I have a tableA: Also TableB Now I want to populate col = code of table B if there exists ID = 2 in tableA. for multiple values , get max value. else populate it with '123...
- Modified
- 14 Mar at 12:23
SELECT * WHERE NOT EXISTS
SELECT * WHERE NOT EXISTS I think I'm going down the right path with this one... Please bear with me as my SQL isn't the greatest I'm trying to query a database to select everything from one table whe...
- Modified
- 2 Oct at 08:45
What's different between Contains and Exists in List<T>?
What's different between Contains and Exists in List? I want to know what's different between `Contains` and `Exists` in `List` ? They can both determine whether an element is in the `List`. But what'...
Servicestack OrmLite "where exists" subquery
Servicestack OrmLite "where exists" subquery No matter how hard I tried I couldn't make it work and I'm not sure if it is possible. I want to select all clients who have at least one order. The first ...
- Modified
- 30 Jul at 12:3
MySQL > Table doesn't exist. But it does (or it should)
MySQL > Table doesn't exist. But it does (or it should) I changed the datadir of a MySQL installation and all the bases moved correctly except for one. I can connect and `USE` the database. `SHOW TABL...
- Modified
- 25 Nov at 11:12
SQL - IF EXISTS UPDATE ELSE INSERT INTO
SQL - IF EXISTS UPDATE ELSE INSERT INTO What I'm trying to do is `INSERT` subscribers in my database, but `IF EXISTS` it should `UPDATE` the row, `ELSE INSERT INTO` a new row. Ofcourse I connect to th...
C# File.Exists returns false, file does exist
C# File.Exists returns false, file does exist Using VS 15, C# with .Net 4.5.2 The computer is on an AD network, with the ad name "AD". This problem happens with AD normal-user rights, AD admin rights,...
- Modified
- 23 Mar at 16:13
How to wait until File.Exists?
How to wait until File.Exists? I have an app, listening for the *.log file in a chosen folder. I used `FileSystemWatcher`. But there is a problem. The other app responsible for making that file takes ...
- Modified
- 16 Nov at 13:44
How can I check if an element exists in the visible DOM?
How can I check if an element exists in the visible DOM? How do you test an element for existence without the use of the `getElementById` method? I have set up a [live demo](http://jsbin.com/apawi5/3)...
- Modified
- 15 Dec at 04:51