Welcome Guest, Not a member yet? Register   Sign In
Search Results
    Thread: Hidden field not been submitted with form validation
Post: RE: Hidden field not been submitted with form vali...

The third parameter test
10,442 Views
5 Replies
12-28-2015, 12:05 AM
andresweb
    Thread: call function postgresql 9.5
Post: RE: call function postgresql 9.5

I tried with a simpler function. Code: -- DROP FUNCTION sp_1() CREATE OR REPLACE FUNCTION sp_1() RETURNS TABLE(codigo character varying, nombre character varying) AS $$ BEGIN RETURN QUER...
3,797 Views
1 Replies
12-27-2015, 11:45 PM
andresweb
    Thread: call function postgresql 9.5
Post: call function postgresql 9.5

I have not found help. Now I created a function in postgresql 9.5 CREATE OR REPLACE FUNCTION certificado_notas() RETURNS TABLE(mat_anio_academico integer, udi_id integer, udi_nombre character var...
3,797 Views
1 Replies
12-27-2015, 08:02 PM
andresweb
    Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

I have not found help. Now I created a function in postgresql 9.5 CREATE OR REPLACE FUNCTION certificado_notas() RETURNS TABLE(mat_anio_academico integer, udi_id integer, udi_nombre character...
7,706 Views
7 Replies
12-27-2015, 07:07 PM
andresweb
    Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

if you find the field! to correct the double quote and try pgadmin3 works. This is the modified query and running SELECT m.mat_anio_academico, mu.udi_id, u.udi_nombre, u.sem_codigo, u.udi_letra...
7,706 Views
7 Replies
12-22-2015, 09:26 AM
andresweb
    Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

I returned to the simple example $subquery = 'SELECT DISTINCT ON (mud.udi_id) mud.mud_id FROM matricula_unidad_didactica AS mud INNER JOIN matricula AS m ON mud.mat_id=m.mat_id INNER JOIN alumno AS...
7,706 Views
7 Replies
12-22-2015, 09:02 AM
andresweb
    Thread: remove the double quotes of a subquery
Post: RE: remove the double quotes of a subquery

thanks for you help. i'm trying with the next code in the subquery. $this->db->order_by('u.sem_codigo', 'ASC'); $this->db->order_by('u.udi_letra_nomina','ASC'); $this->db->order_by('m.mat_anio_ac...
7,706 Views
7 Replies
12-22-2015, 12:02 AM
andresweb
    Thread: remove the double quotes of a subquery
Post: remove the double quotes of a subquery

┬┐how do I remove the double quotes of a subquery in postgresql? i have the example next: Error Number: ERROR: syntax error at or near "AS" LINE 7: ...d"."udi_id" DESC, "m"."mat_anio_academico...
7,706 Views
7 Replies
12-20-2015, 09:57 PM
andresweb

Theme © iAndrew 2016 - Forum software by © MyBB