postgresql - Using price contraints or a function in Postgres for "money" type? -


i'm trying make sure sales prices in postgres database end in either .99 or .00.

if price 34.00, i'd database leave alone. if price 34.34 i'd changed 34.99.

can done entirely inside of postgres, function, or system of contraints? want make sure it's possible before start hammering away @ it.


-

Popular posts from this blog

java - Cannot send AES encrypted messages of over 47 characters -

ello mates! creating aes encrypted chat program have ran issue; whenever message on 47 characters, displays "javax.crypto.illegalblocksizeexception: input length must multiple of 16 when decrypting padded cipher". understand error message can't seem figure out how fix it. here full code: chatclient.java package chat.application; import java.awt.event.actionevent; import java.awt.event.actionlistener; import java.io.bufferedreader; import java.io.ioexception; import java.io.inputstreamreader; import java.io.printwriter; import java.net.socket; import javax.swing.jframe; import javax.swing.joptionpane; import javax.swing.jscrollpane; import javax.swing.jtextarea; import javax.swing.jtextfield; import javax.swing.text.*; import java.security.*; import java.util.logging.level; import java.util.logging.logger; import javax.crypto.*; import javax.crypto.spec.secretkeyspec; import sun.misc.*; import java.net.inetaddress; /* * known bugs: * message size limited 47...
Read more

php - How to set default value of a select dynamically from database using smarty? -

i have select this: <select class="fruitsselect" name="fruits"> <option value="apples">apples</option> <option value="bananas">bananas</option> <option value="oranges">oranges</option> </select> and know can set default value if use selected attribute. <select class="fruitsselect" name="fruits"> <option value="apples">apples</option> <option value="bananas" selected>bananas</option> <option value="oranges">oranges</option> </select> but trying that, value retrieve database (i send html via php ) option retrieve database selected option (the default option). i have value on html not know how make selected option because can change. using smarty , trying make ifs statements cannot out. how can compare value retrieve database value of select , make...
Read more

telerik - Reformat image format in PDF -

i got issues in rendering couple of images , texts in pdf in telerik pdf viewer - according telerik's documentation seems texts/images formats incompatible. are there ways convert existing images in pdf , replace pdf make file compatible telerik pdf viewer? many thanks
Read more