[GENERAL] How to loop through multi-dimentional array in PL/PGSQL

null for product_list[i][0]; Any help would be appreciated. -- Regards : Venktesh Guttedar.

[GENERAL] Multidimentional array access

array_value Help would be appreciated. -- Regards : Venktesh Guttedar.

[GENERAL] Appending to multidimentional array.

Hello, Is there a way to append an array to a multidimentional array? EG: -- Regards : Venktesh Guttedar.

[GENERAL] Appending to multidimentional array.

Hello, Is there a way to append an array to a multidimentional array in PL/PGSQL procedure? EG: Array_1 = [][]; Array_2 = '{1,2,3,4,5}'; Result should be : Array_1 = {{1,2,3,4,5}}; -- Regards : Venktesh Guttedar.

Re: [GENERAL] Appending to multidimentional array.

Hello Chris Travers. Its working. You saved my day.:) Thanks a tons. On Tue, Dec 13, 2016 at 9:18 AM, Chris Travers wrote: > Array_1 :== Array_1 || Array[Array_2] > > I think > > On Tue, Dec 13, 2016 at 6:08 AM, VENKTESH GUTTEDAR < > venkteshgutte...@gmail.c

[GENERAL] Appending new data to existing field of Json data type

} ] } Is there any way to achieve this. please help.! I have Postgresql 9.3.5. -- Regards : Venktesh Guttedar.

[GENERAL] Need Guidance on Appending new data to existing field of Json data type

} ] } Is there any way to achieve this. please help.! I have Postgresql 9.3.5 -- Regards : Venktesh Guttedar.

Re: [GENERAL] Appending new data to existing field of Json data type

example_list ---+ 2 | {"abc":[ { "a":"b","c":"d" }, { "e":"f", "g":"h" } ] } Hope your clear now. So now Guide me to append it through Python Djn

Re: [GENERAL] Appending new data to existing field of Json data type

@Adrian Klaver, Thanks for this idea but still m really confused with how to update the json filed in the DB. is there any way to update the json field in the DB through view.? On Wed, Oct 29, 2014 at 7:37 PM, Adrian Klaver wrote: > On 10/29/2014 01:06 AM, VENKTESH GUTTEDAR wrote: >

Re: [GENERAL] Appending new data to existing field of Json data type

Thanks Adrian Klaver, Its really helped me to solve my problem, ya i have example_list = jsonfield.JSONField() in models. Apologies i did not mention that. but anyways thank again. On Thu, Oct 30, 2014 at 8:09 PM, Adrian Klaver wrote: > On 10/29/2014 11:26 PM, VENKTESH GUTTEDAR wr

[GENERAL] Retrieving Data from table based on Date and Time.

Hello, I have a table in which i have some few fields, in that few, one field is of date type and second one is of time data type, so now my question is how can i fetch the data with latest date and time, or the last inserted value from the PostgreSQL Table.? -- Regards : Venktesh Guttedar.

Re: [GENERAL] Retrieving Data from table based on Date and Time.

Thanks it helped. On Sat, Nov 1, 2014 at 2:09 PM, Stephen Cook wrote: > On 11/1/2014 2:27 AM, VENKTESH GUTTEDAR wrote: > >> I have a table in which i have some few fields, in that few, one >> field is of date type and second one is of time data type, so now my >> que

[GENERAL] Encrypting/Decryption

, so tell me which is right way either to use pgcrypto or pycryto, i am not understanding neither of them. please help. -- Regards : Venktesh Guttedar.

[GENERAL] ERROR: Corrupt ascii-armor

ii-armor. please help me to encrypt data.. or is there any other way to achieve safe encryption and decryption.? -- Regards : Venktesh Guttedar.

[GENERAL] [general] Encrypting/Decryption

, so tell me which is right way either to use pgcrypto or pycryto, i am not understanding neither of them. please help. -- Regards : Venktesh Guttedar.

[GENERAL] [general] Error while decrypting using pgp

am going wrong. and if not then what explicit type casts i have to add.? please help thanks in advance. -- Regards : Venktesh Guttedar.

[GENERAL] Error : Ensure this value has at most 30 characters (it has 31) django

changing the max length to 75 of username field of auth_user. but still i am getting the same error. Please help me to solve this -- Regards : Venktesh Guttedar.

[GENERAL] Storing Video's or vedio file in DB.

files through http post) Help would be appreciated. Thank you. -- Regards : Venktesh Guttedar.

[GENERAL] : Getting error while starting the server

-packages/django/db/backends/postgresql_psycopg2/base.py", line 134, in get_new_connection return Database.connect(**conn_params) File "/usr/local/lib/python3.4/dist-packages/psycopg2/__init__.py", line 164, in connect conn = _connect(dsn, connection_factory=connection_factory, async=async) django.db.utils.OperationalError: could not translate host name "localhost" to address: Name or service not known can anyone tell me what is the reason for this error.? -- Regards : Venktesh Guttedar.

[GENERAL] GENERAL - [How to check if the array contains the element.]

. -- Regards : Venktesh Guttedar.

[GENERAL] GENERAL : [Can somebody explain about Base directory]

Hello All, Base directory is consuming to much memory, leading to no space on server and stopping the application Somebody please explain why it takes so much memory and is it safe to delete those files.? -- Regards : Venktesh Guttedar.