Bytea types wHERE NOT EXISTS


0 votes
asked Mar 16, 2016 by gerache (310 points)
Thanks for any insights. I have following method which inserts images into postgresql database. I have added "WHERE NOT EXISTS" section to query so if image is in databases it would not insert it.

4 Answers

0 votes
answered Mar 30, 2016 by Bcv_6218_ba (910 points)
 
Best answer
Take a look at [PostgreSQL] text and bytea - Grokbase to see how this could work
0 votes
answered Mar 18, 2016 by kaner (310 points)
There is a method that is designed for this
I found a good example at the below link PostgreSQL - Quick Guide - Tutorialspoint
0 votes
answered Apr 4, 2016 by Session (860 points)
Make sure you have this function in your application delegate
We also checked http://www.postgresql.org/docs/8.4/static/datatype-character.html doesn't work neither
0 votes
answered May 13, 2016 by Bs6140Elliff (720 points)
There is no need to write your own function to do this

What is Geekub?

Q&A site for professional and enthusiast programmers, software developers and other technical users. With your help, we hope to work together to build a library of detailed answers to just about any question that is related to programming!







...